Data queries

Drag & drop query columns

If a column is displayed in a grid, it can be customized using Drag & drop. Usage is controlled by the DataQuery role.

The changes made can be manifested locally or globally:

  • Locally - the agent modifies the data grid - it is visible only for them (written in the database table Perso)

  • Globally - modification made via Data queries - visible to everyone who does not have their local modification

    • Settings are written for a specific Data query columns - parameters Column width, Order

    • The changes are reflected immediately; the DataStructures.DataQuery.DataQueryColumns cache is automatically deleted; for more details see Caches

Data query maintenance

For maintaining or creating a query, use Data queries visual editor.