reportdef/parameters

Description

An optional element with definitions referenced by the queries. Used to filter the data that is being requested.

Diagram

media/image32.jpeg

Child Elements

parameter

Example

In the example, the data is filtered three ways: by business date (busDate), location name (locName), and revenue center name (rvc). These parameters are options when running a report in Reporting and Analytics, found within Edit Parameters.

In the advanced editor, you can view the parameters listed under the subject area selected for this query. Possible parameters and parameter names are shown with a Parameter tag in the subject area list on the left. Use the alias name of the column within the name attribute.

<reportdef>
	<properties />
	<queries>
		<query datasource="" name="Query0" result-type="multiple-rows" type="iquery">
			<subjectArea name="Tender Fixed Period Total">
				<columns>
					<column name="rvc" />
					<column name="busHour" />
					<column name="tndrName" />
					<column name="tndrCnt" aggregate="sum" />
					<column name="tndrTtl" aggregate="sum" />
				</columns>
				<orders>
					<order name="busHour" direction="ASC" />
					<order name="tndrName" direction="ASC" />
				</orders>
			</subjectArea>
		</query>
	</queries>
	<parameters>
		<parameter name="busDate" type="list" data-type="date">
			<parameter-default default-type="system" default-value="MostRecentOperations" />
		</parameter>
		<parameter name="locName" type="list" data-type="text" />
		<parameter name="rvc" type="list" data-type="text" />
	</parameters>
	...