Page Comparison

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, group...)

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.

Image Modified

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.

Image Added

Default grouping periods