reportdef/queries/query/subjectArea/filters/filter

Description	This optional element contains the list of columns given in metadata that is used to filter the records. Columns marked as measure (except date, qtrHr, busHour) in metadata can’t be used as filters. The metadata appears in the Subject Area (Alias) section of the advanced editor of the report builder.
Diagram
Child Elements	end, items, start
Attributes	comparison, data, logic, name, type

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