reportdef/queries/query/subjectArea/filters/filter/items/item

Description

Multiple items element is required when using the following list filters:

stringFilter, intFilter, longFilter, doubleFilter.

Sample:

<filter name="surname" type="stringFilter">
    <items>
       <item>Smith</item>
       <item>Johnson</item>
       <item>Brown</item>
    </items>
</filter>

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