Create a User-Defined Query

Create a user-defined query to define the data that you want to extract. After you create the query, you can add it to an extract definition.

1. From the Navigator, select Tools > Data Extraction.

2. Select User-Defined Queries.

3. Select Create.

4. Enter a name for the query.

5. Optionally, enter a description.

6. Select the applicable pillar and family.

7. Enter tags, as needed.

8. Select an execution mode.

   • Select Synchronous for a query that completes quickly and must return a result immediately.

   • Select Asynchronous for a long-running query or a query that extracts a large volume of data.

9. Enter the query definition.

10. Select Create.

You can now add the user-defined query to an extract definition. For more information, see Create an Extract Definition Using User-Defined Queries.