reportdef/queries/query/subjectArea/orders

Description	This optional element contains the list of columns given in metadata that is used to order the items. The metadata appears in the Subject Area (Alias) section of the advanced editor of the report builder.
Diagram
Child Elements	order

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