reportdef/queries/query/subjectArea/filters/filter/items
Description |
Required when using the list filter, it is a wrapper element for item element.. |
Diagram |
|
Child Elements |
Example
The example shows return records
from Tender Daily Total
between business dates 2019-11-22
and 2019-11-27
with tndrNum
> 10
and order the returns values
by revenue center.
... <query datasource="" name="Query0" result-type="multiple-rows" type="iquery"> <subjectArea name="Tender Daily Total"> <columns> <column name="rvc" /> <column name="tndrName" /> <column name="tndrCnt" aggregate="sum" /> <column name="tndrTtl" aggregate="sum" /> </columns> <orders> <order name="rvc" direction="ASC" /> </orders> <filters> <filter name="busDate" type="dateRangeFilter"> <start>2019-11-22</start> <end>2019-11-27</end> </filter> <filter name="tndrNum" type="relationalFilter" comparison="GREATER_THAN"> <data>10</data> </filter> </filters> </subjectArea> </query> ...
Parent topic: Elements