Implementing Microsoft Dynamics 365 Business Central On-Premise - Fourth Edition

Queries object in Microsoft AL

It's also possible to create new queries from Visual Studio Code. The tquery shortcut will create the basic layout for a new Query object when using the Microsoft AL Language extension in Visual Studio Code.

Here is an example:

query Id MyNewQuery {   QueryType = Normal;              elements         {                 dataitem(DataItemName; SourceTableName)                 {                         column(ColumnName; SourceFieldName)                         {            }                         filter(FilterName; SourceFieldName)                         {             }            }              var                 myInt: Integer;              trigger OnBeforeOpen()         begin                  end; }

For more information, you can visit https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-query-object.