Conditions

Once entities are added to this section, users can define conditions, based on which the data is displayed in the report. Users can also search for and add entities for using the [Add new condition] option. The parameters for defining conditions may vary based on the entity selected.

The following conditions can be defined for records to be displayed in the report:

  • On a high level, records are displayed only if all, any, none, or not all conditions are met. To do so, click all in Select records where all of the following apply and select the preferred option.

    • any - records are displayed if any of the conditions are met

    • all - records are displayed only if all conditions are met

    • none - records are displayed even if none of the conditions are met

    • not all - records are displayed even if more than one condition is met

  • Group conditions using the Add group of conditions icon.

  • Work with subqueries.

  • Enable or disable conditions and condition groups.

  • Conditions can be deleted at any time.