The Query Interface brings together the Editor, Results, and Resources on a single page.
Opening the NQI
To access the query interace:
Click the Use-Query-in-Search icon from a dashboard or report widget. The new interface displays.
Video: Opening the NQI from a Report
Editor
This panel dislays your SQL query and provides the following functionality:
A green check mark displays when the SQL syntax is valid. A red warning sign indicates that there is an error.
Toggles the Resources sidebar open and closed
Displays the Address Space Visualization tool.
Runs the current query
Analyzes the query. The query plan and parameters associated with the query are available on tabs.
Resources
Displays lists of Queries and Tables available on your Lumeta system.
Results
The records returned by your query.
Sort & Filter Columns Click the Sort-by icon (i.e., the down arrow) to sort table columns throughout Lumeta. 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.
Columnar 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.
Column Control & Indicator
Ascending
Descending
Filtered
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 formats