Executing the Query¶

Data Contextualization Query Service creates Job executions for Static Queries and Dynamic Queries. The Query execution process runs a Query plan and returns the results to the Query.

Executing a Static Query¶

A Static Query statement includes all of the information required to run the Query. When a user creates a static query in the Data Contextualization application, the query is executed automatically. To view the status of Static Query Execution, refer Query Execution Jobs.

Executing a Dynamic Query¶

A Dynamic Query has one or more parameters, the values of which must be provided before the Query Execution. After executing a Dynamic Query, the user can see the status of the execution in the "Jobs" user interface. The below section explains the steps to execute a Dynamic Query.

Procedure¶

To execute a Dynamic Query, follow these steps:

1. From the left navigation, click "Queries".
2. Select the required Dynamic Query, click under "Execution(s)" to view the execution page.

3. Click "Execute" and enter the Variable data.

   

4. To edit the component details, disable the toggle button .

5. Click "Execute".

   

A Query is successfully executed.

Deleting the Query¶

To delete the folder or object, follow these steps:

1. In Queries, select the folder or object that needs to be deleted.
2. Click .
3. Click "Yes, delete query".

A Query is successfully deleted.