reportdef/queries/query/subjectArea/filters/filter/data

Description

An optional element. This is the data that will be compared with column in order to filter the records. Appropriate format must be followed for data. For example, for date/datetime column, data must be in ISO8601 format. Date/datetime column: yyyy-MM-dd yyyy-MM-dd HH:mm:ss hour-min-sec formatted column: HH:mm:ss HH:mm HH IS_NULL, IS_NOT_NULL ignores the data element. It is only applicable if filter type= relationalFilter

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>
...