Smart query editor

[ 1 Overview ] [ 2 How does it work? ] [ 3 LINQ syntax categories ]

Overview

The Devo query editor is equipped with an autocompletion functionality that suggests all the available LINQ syntax options at any step of your query, based on the text you are typing.

When there’s any suggestion available for the text you type, the editor will display a popup window showing all the available LINQ possibilities.

The smart query editor features are available in the Free text query area (Data search → Explore your data → Free text query) and in the Query code editor after running a search.

How does it work?

As said above, simply start writing your query and you will be prompted with different options based on your text. The editor also detects if the clause/operation/text entered is properly placed; if you don’t get any match, it means that that text is not correctly placed.

Press the ENTER key to add the recommended option according to the typed letters. This option is highlighted in green in the popup window. Otherwise, select the required option by clicking on it or navigating through the list with the arrow keys.

Shortcuts

CTRL + SPACE - Opens the popup window with the available suggestions.
CTRL + enter - Runs the query.

LINQ syntax categories

The smart editor suggests different types of syntax categories, which are marked in the popup window with a specific icon. These are the most relevant ones:

Category	Description	Icon

Category	Description	Icon
Data tables	Available and accessible data table levels will appear when you start typing a table name. Write a `from` clause to start your query. Then, type the first letter of the first table level. All the available options will appear in the popup window. Then, type a dot (.) and start typing the second table level to get all the available options. Keep on doing that until you type the whole table name. Note that you will only get levels from tables to which you have access. Learn more about data tables and tags in this article.
LINQ clauses	LINQ clauses appear in the popup window whenever they can be used. These keywords are the ones use to enter the different query operations available (`from`, `where`, `select`, `as`, `group`, `by`...) As any other term, the clauses matching the letters you type will appear in the list. Learn more about the available reserved clauses in the LINQ syntax in this article.
LINQ operations	Valid and available LINQ operations will appear in the list after the required clause. In case of aggregation operations, they will always appear in the list with (aggr) after their name, as you can see in the following capture: See the whole list of operations available in our Operations reference.
Table fields	Table fields in the specified data table will appear preceded by this symbol. The data type of the field will be specified after its name. You will get results that match either the field name or the data type.
Grouping periods	Time grouping periods entered after an `every` clause will appear marked with this symbol. Learn more about time-based grouping in this article.