How to Create query extension

Rumman Ansari   Software Engineer   2025-01-20 09:37:00   168  Share
Subject Syllabus DetailsSubject Details
☰ TContent
☰Fullscreen

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.

How to Create query extension
Figure: How to Create query extension

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.

Query extension name with the model name
Figure: Query extension name with the model name

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.



No Questions Data Available.
No Program Data.