<!-- выбирать всех Иваоновых Иванов родившихся с 1960-года, будет выбираться только ФИО--!>
        <queryInfo tableName="person">
            <columns fullColumnName="person_id"  isSelect="false"/>
            <columns fullColumnName="lastname" whereComparison="eq" value="ИВАНОВ"/>
            <columns fullColumnName="firstname" whereComparison="eq" value="ИВАН"/>
            <columns fullColumnName="patronymic" />
            <columns fullColumnName="datebirth" isSelect="false" whereComparison="gt" value="01.01.1960"/>
        </queryInfo>

<!-- посчитать количество сгруппированное по фамилии. --!>
        <queryInfo tableName="person">
            <columns fullColumnName="person_id" groupType="count"/>
            <columns fullColumnName="lastname" />
        </queryInfo>

<!-- выбрать персоны работающие в отделе разработки. --!>
        <queryInfo tableName="person">
            <columns fullColumnName="person_id" />
            <columns fullColumnName="lastname" />
            <columns fullColumnName="firstname" />
            <columns fullColumnName="department_id.department.deparment_name" whereComparison="eq" value="отдел разработки"  />
        </queryInfo>

<!-- выбрать персоны без отделов. --!>
        <queryInfo tableName="person">
            <columns fullColumnName="person_id" />
            <columns fullColumnName="lastname" />
            <columns fullColumnName="firstname" />
            <columns fullColumnName="department_id.+department.deparment_name" whereComparison="is_null"  />
        </queryInfo>
    

<queryInfo tableName="person">

<columns fullColumnName="lastname" />

<columns fullColumnName="department_id.+department.deparment_name" whereComparison="is_null"  />

<preparedQueries name="center_replic_node">
        <captions language="RU" caption="Репликация"/>
        <queryRequestTable linkTableName="center_replic_node" linkColumnName="id_university,oper_type">
            <selectColumns columnName="id_university,oper_type" isSelect="true"/>
            <selectColumns columnName="oper_type" filterComparison="eq" isSelect="true"/>
            <selectColumns columnName="ip_adress" isSelect="true"/>
            <selectColumns columnName="oper_datetime" isSelect="true" filterComparison="lt"/>
            <selectColumns columnName="status" isSelect="true" filterComparison="eq"/>
            <selectColumns columnName="id_university" filterComparison="eq" isSelect="false" orderByIndex="1">
                <foreignQueryRequestTables linkTableName="universities" linkColumnName="id_university" joinType="right">
                    <selectColumns columnName="nameru" isSelect="true"/>
                    <selectColumns columnName="mylabel"  isSelect="true" filterComparison="eq"/>
                </foreignQueryRequestTables>
            </selectColumns>
        </queryRequestTable>
    </preparedQueries>