Set filters for queries in report scripts

In report scripts, you can configure filters for queries by setting parameters. Filters are used to limit queries to a specific result set, for example, only models of the EPC type.

Depending on the data element that is set for a query, different parameters are available for selection.

Prerequisite

You have created a report script in design view.

Procedure

  1. Open a report script in the design view of Script Editor.

  2. In the Structure column, right-click a query for which you want to set filters.

  3. Click Properties in the pop-up menu.

  4. Activate the Parameters page.

  5. Select the relevant query in the Queries box.

  6. In the Parameters box, set the relevant filter for the selected query.

  7. Click OK.

Your changes are transferred to the report script.

Example

Set filters for a query

For most data elements, you can define filters to restrict the evaluation to a specific dataset such as only models of the EPC type.

Queries

First select a set query in the Parameters dialog, and then set the relevant filters in the Parameters box.

Parameter

Depending on the data element selected, different filters are available for selection. For some data elements, you can only set one filter, which is usually preset. For other data elements, you can set multiple filters, which are usually optional. For some data elements, you can also set additional filters such as a specific attribute value. If a data element has a superior item, you can additionally set a filter for the superior item.

Alias name

Independent of filter settings, you can give a query an alias name of your choice.

Sorting

You can set the sort order for the output of data in the report. The selectable sort parameters depend on the data element of the selected query.

Example: Set filters for Model list data element

Set parameters of a query

See also

How are queries defined in report scripts?