Skip to main content

Creating Standard Queries

DPL Studio ›› Data Selection: Queries>>Standard Queries>>

Creating Standard Queries​

Creating a Standard Query​

  1. To Create a New Standard Query should have minimum one existing pack or create the new pack,
  2. Navigate to the Models à New Standard Query or Right click choose New Standard Query

Add a Table

  1. Available tables from the connected data source will be displayed in the right panel.
  2. Drag and drop the required table into the workflow.

Select Fields

  1. Select the required columns using the checkboxes.
  2. To select all fields, click Select All or which fields need select that.

Preview Data

  1. Navigate to DPL Pack → Preview.
  2. Verify that the required data is displayed correctly.

standard queries 2

Understanding the Standard Query Menus​

The Standard Query Editor contains multiple sections that assist in query creation and management.

standard queries

Toolbar Options​

The toolbar provides quick access to commonly used actions:

  1. View Data – Displays the selected table data
  2. Delete – Removes the selected item
  3. Rename – Renames the selected query or field
  4. Quick Export – Exports query results directly
  5. Create Reusable Queries – Creates reusable query components
  6. Edit – Modifies query settings
  7. Description – Adds query descriptions or notes
  8. Filter Wizard – Opens the filter configuration window
  9. Select Columns Wizard – Allows column selection management

Filtering and Customizing Data​

To customize the query output:

  1. Select a field within the table.
  2. Right-click on the field.
  3. A context menu will appear with multiple configuration options.

standard queries 1

Available Options​

  1. Alias
  2. Add filter
  3. Add to group
  4. Add to order

Alias : Allows the selected field name to be renamed in the query output.

Add Filter : Applies conditions to filter specific records from the dataset.

Add to Group : Groups records based on the selected field. If multiple grouping conditions are added, they will appear under the Group Conditions section.

Add to Order : Sorts data in - Ascending order, Descending order. The sorting configuration will appear under the Order Conditions section.

Finalizing the Standard Query​

  1. Click DPL Pack → Preview to validate the output.
  2. Save the query after verification.