<query id="getGrantedModules" action="select">
    <tables>
        <table name="module_grants" />
    </tables>
    <columns>
        <column name="module_srl" />
    </columns>
    <conditions>
        <condition operation="in" column="name" default="'access','view','list'" notnull="notnull" />
        <group pipe="and">
            <condition operation="more" column="group_srl" default="1" notnull="notnull" />
            <condition operation="equal" column="group_srl" default="-1" notnull="notnull" pipe="or" />
            <condition operation="equal" column="group_srl" default="-2" notnull="notnull" pipe="or" />
        </group>
    </conditions>
    <groups>
        <group column="module_srl" />
    </groups>
</query>
