Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
titleENTER
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.

Info

Shortcuts

  • Status
    titleCTRL
    +
    Status
    titleSPACE
    - Opens the popup window with the available suggestions.

  • Status
    titleCTRL
    +
    Status
    titleenter
    - 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

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.

Image RemovedImage Added

Then, type a dot (.) and start typing the second table level to get all the available options.

Image RemovedImage Added

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.

Image Removed
Image Added

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.

Image RemovedImage Added

Learn more about the available reserved clauses in the LINQ syntax in this article.

Image Removed
Image Added

LINQ operationsImage Removed

Valid and available LINQ operations will appear in the list after the required clause.

Image Added

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:

Image RemovedImage Added

See the whole list of operations available in our Operations reference.

Image Removed
Image Added

Table fields

Default grouping periods

...

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.

Image Added

You will get results that match either the field name or the data type.

Image Added

Grouping periods

Time grouping periods entered after an every clause will appear marked with this symbol.

Image Added

Learn more about time-based grouping in this article.

Image Added