Skip to main content

Data Selection: Queries

DPL Queries​

Queries within the DPL environment encapsulate a process that produces tabular data. DPL queries should not be confused with SQL queries or functions that return tables. While SQL queries or functions can be encapsulated within a query, they generally serve as building blocks of a more complex Digital Process Logic query.

DPL provides three types of queries:

  1. Standard Queries
  2. Aggregate Queries
  3. Transform Queries

Each query type uses a different process to retrieve or construct data. However, once created, all query types are treated uniformly within the DPL environment and can be managed using the same procedures.

Organizing Queries​

The Queries folder in the Data pane can contain multiple queries. For better organization, queries can be grouped into categories.

Creating a Category​

  1. Right-click the Queries folder.
  2. Select New Category.
  3. Enter a category name.

Moving Queries to a Category​

  1. Select the desired query.
  2. Drag and drop the query into the appropriate category folder.

Query Management​

The Queries folder supports standard query management operations:

Edit a Query​

  1. Right-click the query.
  2. Select Edit.

The query opens in a new tab for modification.

Add a Description​

  1. Right-click the query.
  2. Select Description.
  3. Enter the description in the Description dialog box.
  4. Click OK.

Delete a Query​

  1. Right-click the query.
  2. Select Delete.

Duplicate a Query​

  1. Right-click the query.
  2. Select Duplicate.

Duplicating a query creates an exact copy, allowing you to modify parameters without affecting the original query.

Rename a Query​

  1. Right-click the query.
  2. Select Rename.
  3. Enter the new query name.

Quick Export a Query​

  1. Right-click the query.
  2. Select Quick Export.

This option allows you to export query results directly. For more information, refer to the Quick Export section.