Variables in ADQL Queries

Variables in ADQL Queries

Variables in ADQL queries enable you to dynamically change the values passed into the queries.

For example, you want to use a variable for an application within an ADQL query.

  1. Click + Add Variable under the Dashboard Variables panel. Add Variable
  2. Enter a value in the Variable Name field and select the variable type in the Type dropdown. Variable Name Value
  3. Select an application in the Application dropdown. Application Menu
    The subsequent inputs shown in the Dashboard Variables panel are specific to the data type selected in the previous step. In this example, it is the Initial Values dropdown, which enables you to select the business transaction for which you want to drill down the data. Dashboard Variable
  4. Select the Initial Values, and then select the Show in View Mode checkbox. Click the widget to change Data Panel from variable data to widget data.
  5. Choose a value from the Show me data for dropdown. You can select ADQL Query, and then enter the query in the ADQL Query field. After you enter a valid query, the widget displays.
    The following is an example of how to use variables as $app in an ADQL query:
    SELECT transactionName FROM transactions WHERE application= "${app}"
  6. Click View on the top-right of the page. The subsequent dashboard page enables you to change the application by clicking the $app dropdown.