InovacaoMediaBrasil/ProcessWorkflowsAndDatabaseScripts

<gadget>
    <prompt-parameters>
        <parameter id="DATA_INICIAL" description="DATA_INICIAL" metadata="date" required="true" keep-last="false"/>
        <parameter id="DATA_FINAL" description="DATA_FINAL" metadata="date" required="true" keep-last="false"/>
    </prompt-parameters>
    <level id="lvl_yz10ru" description="Principal">
        <grid id="grd_yz10rv">
            <title>
                <![CDATA[ICMS]]>
            </title>
            <expression type="sql" data-source="MGEDS">
                <![CDATA[/* Gerada pelo SankhyaW QueryBuilder */ SELECT          CabecalhoNota.NUMNOTA,          CabecalhoNota.VLRNOTA,          CabecalhoNota.BASEICMS,          CabecalhoNota.VLRICMS  FROM          TGFCAB CabecalhoNota  WHERE CabecalhoNota.TPAMBNFE = 1          AND CabecalhoNota.STATUSNFE = 'A'          AND CabecalhoNota.CODTIPOPER = 550          AND CabecalhoNota.DTNEG >= :DATA_INICIAL          AND CabecalhoNota.DTNEG <= :DATA_FINAL]]>
            </expression>
            <metadata>
                <field name="NUMNOTA" label="NUMNOTA" type="I" visible="true"/>
                <field name="VLRNOTA" label="VLRNOTA" type="F" visible="true"/>
                <field name="BASEICMS" label="BASEICMS" type="F" visible="true"/>
                <field name="VLRICMS" label="VLRICMS" type="F" visible="true"/>
            </metadata>
        </grid>
    </level>
</gadget>