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

Table fields

Defaulr grouping periods