Skip to main content

Query Actions

Queries built with the Query Designer have top-level actions that let you modify or view the Query's elements in bulk.

Options menu​

Click the ... button in the top-left corner of a Query's Edit screen to open a menu with several Query actions.

The Query Actions menu with Manage Fields, Remove all Fields, View code, Clear Field settings, and Remove all Flow Steps
The Query Actions menu.

Manage Fields​

This action opens a window for changing the names, aliases, or data types of Fields. You can edit multiple Fields at once, which saves time compared to changing them one at a time. Click a Field's name, alias, or data type to change it. Click the X to the right of a Field's row to remove it, or Remove All to remove every Field.

The Manage Fields window listing Fields with Name, Alias, and Data Type columns
The Manage Fields window.

Remove All Fields​

This action prompts for confirmation, then removes all data Fields in the Query. This is helpful when you need to start over.

The Remove all Fields confirmation dialog
The Remove all Fields dialog.

View Code​

This action shows the native query statement created by the Query Designer, which is helpful when debugging why a complex Query is not working. Use the Copy button to copy the code for use elsewhere.

The View Query Code dialog showing the generated SQL statement
The Query Code window.

Clear Field Settings​

This action resets all Field settings to their default configurations.

Remove All Flow Steps​

This action prompts for confirmation, then removes all of the Flow Steps from the Query. This is helpful when debugging and building out Flow Steps.

The Remove all Flow Steps confirmation dialog
The Remove all Flow Steps window.
Also available through the REST API
Everything on this page is built on Informer's public REST API, the same one the product uses, so your scripts and integrations can do it too. Developer reference: Queries.