2.9.1.1. Коллекция

<collection name="{name}" idField="id" replace="runtime">
    <prototype>
        <![CDATA[SELECT
	                  role.id,
					  role.id_type as typeId,
					  '<id>' as open_id_tag,
					  ':' as separate,
					  '</>' as close_id_tag,
					  '<basedocid>' AS basedocid_1,
					  ss_module_org.Module,
					  role.fullname as fullname
	                FROM
	                    so_role role
	                    natural join so_unit
	                    left join so_structureunit su on su.id = role.headorbranchoffice
	                	::from-clause
	                WHERE
	                	role.accessredirect is null
	                    ::where-clause]]>
    </prototype>
    <counting-prototype>
        <![CDATA[SELECT
                    COUNT(*)
                	FROM (SELECT
	                  role.id,
					  role.id_type as typeId,
					  '<id>' as self_1,
					  ':' as self_2,
					  '</>' as close_tag,
					  '<basedocid>' AS basedocid_1,
					  ss_module_org.Module,
					  role.fullname as fullname
	                FROM
	                    so_role role
	                    natural join so_unit
	                    left join so_structureunit su on su.id = role.headorbranchoffice
	                	::from-clause
	                WHERE
	                	role.accessredirect is null
						::where-clause)]]>
    </counting-prototype>
 	<filter name="MODULE">
        <reference placeholder="from-clause">
            <![CDATA[                  
					join SS_ModuleOrg ss_module_org on ss_module_org.Organization = role.organization
					join ss_module ss_module on ss_module_org.module = ss_module.id
            		join ss_moduletype ss_moduletype on ss_module.type = ss_moduletype.id and ss_moduletype.alias ='SO']]>
        </reference>
        <criteria placeholder="where-clause">
            <![CDATA[
                    ss_module_org.Module = {0}
                ]]>
        </criteria>
    </filter>
  	<!-- Фильтр по колонке. Полное совпадение -->
	<filter name="fullname">
    	<criteria placeholder="where-clause">
        	<![CDATA[
				t.fullname = {0}
           	]]>
    	</criteria>
    </filter>
 	<!-- Фильтр по колонке. Частичное совпадение -->
	<filter name="fullname_partial">
    	<criteria placeholder="where-clause">
        	<![CDATA[
       			t.fullname ~* ('(^|\W)'||trim({0}))
           	]]>
    	</criteria>
    </filter>   
	<!-- Поиск по представлению -->
	<filter name="CQSEARCH">
    	<criteria placeholder="where-clause">
        	<![CDATA[
    			fullname ~* ('(^|\W)'||trim({0}))
           	]]>
    	</criteria>
    </filter>  
</collection>