<MP0116_GetGridDataOnly_001 xmlns="http://schemas.datastream.net/MP_functions/MP0116_GetGridDataOnly_001" xmlns:dsg='http://schemas.datastream.net/MP_functions/GridRequest" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.datastream.net/MP_functions/MP0116_Get GridDataOnly_001
C:\shotgun\resources\build\schemas\Grid\MP0116_GetGridDataOnly_001.xsd">
<FUNCTION_REQUEST_INFO REQUEST_TYPE="LIST.DATA_ONLY.STORED">
<GRID_TYPE TYPE= "LIST"/>
<GRID GRID_ID="93" GRID_NAME= "WSJOBS" NEWFUNCNAME="AddWorkOrder" USER_FUNCTION_NAME="WSJOBS"/>
<DATASPY DATASPY_ID= "94"/>
<MULTIADDON_FILTERS>
<MADDON_FILTER SEQNUM="1" LPAREN="true" ALIAS_NAME="organization" OPERATOR="BEGINS" VALUE="rg" RPAREN="false" JOINER="OR" />
<MADDON_FILTER SEQNUM="2" LPAREN="false" ALIAS_NAME="organization" OPERATOR="BEGINS" VALUE="o" RPAREN="true" JOINER="AND" />
<MADDON_FILTER SEQNUM="3" LPAREN="false" ALIAS_NAME="workordernum" OPERATOR="BEGINS" VALUE="100" RPAREN="false" />
</MULTIADDON_FILTERS>
<ADDON_SORT ALIAS_NAME= "workordernum" TYPE= "ASC"/>
</FUNCTION_REQUEST_INFO>
</MP0116_GetGridDataOnly_001>
This would result in an additional filter to the query as follows:
(organization like ‘rg%’ or organization like ‘o%’) and workordernum like ‘100%’