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.
The saved query appears in the application page builder under PAGE DATA > Query > Entities.
Go to the application page builder to apply and execute the query.