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.

...

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 operations

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

Image RemovedImage 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

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 RemovedImage Added

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

Image Removed
Image Added

Grouping periods

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

Image RemovedImage Added

Learn more about time-based grouping in this article.

Image Removed

...

Image Added