2.9.1. Коллекции

<collection name="{name}" idField="id" replace="runtime">
    <prototype>
        <![CDATA[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]]>
    </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
                ]]>
        </reference>
        <criteria placeholder="where-clause">
            <![CDATA[
                    ss_module_org.Module = {0}
                ]]>
        </criteria>
    </filter>
</collection>