You can use presets to simplify work with queries if you regularly view data for a specific set of event fields. In the line with the SQL query, you can type Select *
and select a saved preset; in that case, the output is limited only to the fields specified in the preset. This method slows down performance but eliminates the need to write a query manually every time.
Presets are saved on the KUMA Core server and are available to all KUMA users of the specified tenant.
To create a preset:
To simplify your search, you can start typing the field name in the Search area.
The New preset window opens.
The preset is created and saved.
To apply a preset:
The fields from the selected preset are added to the SQL query field, and the columns are added to the table. No changes are made in Builder.
After the query execution completes, the columns are filled in.