Business Central query objects enable you to retrieve records from one or more tables and then combine the data into rows and columns in a single dataset. Query objects can also perform calculations on data, such finding the sum or average of all values in a column of the dataset.
Articles in this series:
- How to calculate the total (sum) of a column in a table (Four ways)
- How to find duplicates via AL (Filter for duplicate values)
- How to make a query searchable (Add Query to Tell me)
- How to use a query to create a report dataset (Creating Report with Query)
- Using the query as a data source for a page (Query.Open Method)
- API query type (Develop a custom API using Query)
- QueryCategory property – Smartlist? (Execute Queries from Pages)
- Analyze, group, and pivot data on queries using multiple tabs (In-client Analysis mode in Query)
- How to find the last second record in the table via AL (Four ways)
- Support for SaveAsJson on the Query object
- Tooltips on query columns (ToolTip Property & ToolTipML Property)
- Do ad hoc analysis on fixed assets, projects, and services (New Out-of-the-box queries)
How to calculate the total (sum) of a column in a table (Four ways)
How to calculate the total (sum) of a column in a table (Four ways)
How to find duplicates via AL (Filter for duplicate values)
How to find duplicates via AL (Filter for duplicate values)
How to make a query searchable (Add Query to Tell me)
How to make a query searchable (Add Query to Tell me)
How to use a query to create a report dataset (Creating Report with Query)
How to use a query to create a report dataset (Creating Report with Query)
Using the query as a data source for a page (Query.Open Method)
Using the query as a data source for a page (Query.Open Method)
API query type (Develop a custom API using Query)
API query type (Develop a custom API using Query)
QueryCategory property – Smartlist? (Execute Queries from Pages)
QueryCategory property – Smartlist? (Execute Queries from Pages)
Analyze, group, and pivot data on queries using multiple tabs (In-client Analysis mode in Query)
Analyze, group, and pivot data on queries using multiple tabs (In-client Analysis mode in Query)
How to find the last second record in the table via AL (Four ways)
How to find the last second record in the table via AL (Four ways)
Support for SaveAsJson on the Query object
Support for SaveAsJson on the Query object
Tooltips on query columns (ToolTip Property & ToolTipML Property)
Tooltips on query columns (ToolTip Property & ToolTipML Property)
Do ad hoc analysis on fixed assets, projects, and services (New Out-of-the-box queries)
Do ad hoc analysis on fixed assets, projects, and services (New Out-of-the-box queries)
コメント