reportdef/parameters
Description |
An optional element with definitions referenced by the queries. Used to filter the data that is being requested. |
Diagram |
|
Child Elements |
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> ...
Parent topic: Elements