Скачать или смотреть Use the query object to improve retrieval speed of heavy tables.

THE QUERY OBJECT

Using the query objects generates a single sql query to generate massive data.

You can specify the QueryType property, where you can select API or the default Normal value.

A query of type API can be published as a web service that can be used in Power BI reports or other Microsoft Power Platform applications.

The data of a query can also be exported to an XML or CSV file.

You can use the SaveAsXml or SaveAsCsv functions. These functions can write the data to an OutStream data type.

a query supports joining different tables with the SqlJoinType property, filter functions and aggregation functions also exist.

When you access a query in AL code, you need to use the Open function to open access to the query and use the Read function to retrieve the data in the query. Iterating through the query dataset is done with a While..Do statement, whereas iterating through a recordset is done with a Repeat..Until statement.

/*
SELECT - Item of type Column

FROM - Item of type DataItem

JOIN type - SqlJoinType query properties

ON - DataItemLink data item property

WHERE - DataItemTableFilter data item property. ColumnFilter property of columns

HAVING - ColumnFilter property of columns and filters when aggregation is used

GROUP BY - Automatically active for each column item when aggregation is used

ORDER BY - OrderBy query property

TOP - TopNumberOfRows query property
*/

The Contents

0:00 (Introduction)
2:55 (Create a new query)
8:45 (Test the created query)
11:36 (Conclusion)