get-all-tasks.xml

<sub-flow name="get-all-tasks-subflow">
    <logger doc:name="Logger" doc:id="ndehql" message="Start - Get all tasks - HELLOOOOO" />
    <ee:transform doc:name="create sql query" doc:id="fkcolw">
        <ee:message>
            <ee:set-payload doc:name="Set payload" doc:id="xhyrro" resource="dw/get-all-tasks-request.dwl" />
        </ee:message>
    </ee:transform>
    <db:select doc:name="Select" doc:id="pigbzt" config-ref="Mysql_Database_Config">
        <db:sql>
            <![CDATA[#[payload]]]>
        </db:sql>
    </db:select>
    <ee:transform doc:name="to json response" doc:id="hkvahu">
        <ee:message>
            <ee:set-payload doc:name="Set payload" doc:id="miiqpi" resource="dw/get-all-tasks-response.dwl" />
        </ee:message>
    </ee:transform>
    <logger doc:name="Logger" doc:id="vuuads" message="End - Get all tasks" />
</sub-flow>