REPORTING User-Defined Queries

Report Settings => User-Defined Queries:

This allow the connected user to manage User-Defined Queries based on the metadata of all entities.

The User-Defined Query is defined with the following:

Selected entity with its embedded sub entities.

Selected fields of the main entity and its sub entities.

Conditions to be defined on the fields of the main entity and its sub entities.

Computed field defined with operations on the fields of the main entity and its sub entities.

Each selected field or computed field can have different features to be applied in the grid:

Pinned.

Fixed.

Hidden.

Hyperlink.

Groupable.

Aggregatable.

Alignment.

Display Name to replace the metadata name of the field.

Conditional Formatting based on formatting to be applied to values responding to defined conditions.

Formatting = Font Color, Font Background, Bold, Italic, Underline.