How to Create query extension
Table of Content:
Manage and use queries
You can use predefined queries for reports, forms, views, and much more. They’re available in the Application Explorer or Solution Explorer, and you can drag them to your data source node to use them. Additionally, you can select them on the query property in the data source.
Before using a query or query extension, you need to build them.
Extend queries
To extend a query, locate it in the Application Explorer, right-click the view or activate the Context menu, and then select Create extension, as shown in the following screenshot.

After you’ve created an extension for a query, it appears in the project in Solution Explorer. The name of the original query is appended to the extension name with the model name, as shown in the following screenshot.

When extending a query, you can:
- Change labels.
- Add new data sources.
- Add new fields.
Tip
If you set the Dynamic Fields property to Yes on the data source, the system adds new fields automatically to the query field list. Therefore, an extension for the query isn’t needed for new fields.
- Add a new grouping, ordering, and having.
However, you can’t remove existing data sources, fields, grouping, ordering, or having.