...
The smart query editor features are available in the Free text query area (Data search → Explore Your Data your data → Free text query) and in the Query code editor after running a search.
...
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.These are some of the smart query editor features:
Press the
Status | ||
---|---|---|
|
Info | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Shortcuts
|
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 |
---|---|---|
Data tables | Available and accessible data table levels will appear when you start typing a table name. Write a 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 ( 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 periodsDefault | Time grouping periods |
...
entered after an Learn more about time-based grouping in this article. |