Create an Extension Query

Extension type queries work with multiple data sources.

1. In the main navigation menu, select QUERIES.
   The QUERIES workspace appears.
2. Select Add new query.
   The New Query window appears.
3. Provide these details:

   Field	Description
   Name	Enter a name that contains at least one uppercase or lowercase letter.
   Description	Enter a brief description for the query.
   Type	Select Extension.
   Method	Select the type of query you want to create from these options: Read Write Add Comment The Query Parameters and Output Data are loaded based on the method selected for the query.

4. Provide the query parameter values for the required fields.
   • Fixed Value: If this option is selected, the provided value is considered as a fixed value for the field. Fixed value fields are not shown in the application page builder.
   • Input Field: If this option is selected, the provided value appears as a default value for the field in the page builder. Any value provided before executing the query overrides the default value.
5. Select next to the parameters you do not want to include in your query.
   To retrieve deleted query parameters and output data, select +Add All Query Params and +Add All Outputs respectively.
6. Save the query.
   The extension query is created.