Query Interface
The Query Interface brings together the Editor, Results, and Resources on a single page.
Open the NQI
To access the query interface:
Click the Use-Query-in-Search icon from a dashboard or report widget.
Resources
Displays lists of Queries and Tables available on your Asset Manager system.
Results
The records returned by the query.
-
Sort & Filter Columns
Click the Sort-by icon (i.e., the down arrow) to sort table columns throughout Asset Manager. Columns may be sorted in ascending or descending order and key-off a single, user-selected "primary" column. You can continue sorting by a "secondary" column, provided the values in that secondary column are a subset of the values in the first. For example, if the primary column contains only the values True and False, a Secondary column could be sorted alphabetically within all of the True rows and then alphabetically within all of the False rows. If you then wanted to make your secondary sort column a primary sort column, you would first need to first "unsort" the primary column. -
Column data can now be filtered–just enter a "filter-by" string in the Filter field. Only data that matches your filter criteria displays. After a table column has been filtered, the Column Filtered indicator displays.
-
Utility Tray—The new Grid Utility is available at the bottom-right corner of Report pages (i.e., Reports > Browse Real-Time). It also displays whenever you hover your mouse cursor over a dashboard widget. The Grid Utility provides these options:
- Info—Provides information on the selected report or dashboard widget including its source name and type, and which filters and parameters were applied to that source.
- Use Query in Search
- Print—Provides a standard print-from-browser capability.
- Export—Export results to CSV, JSON, or NDJSON file formats.