Skip to main content Skip to complementary content

Creating and saving a group of queries

Availability-noteDeprecated

About this task

In the QBE page you have access to a Query Catalog panel to the right of the Query Editor. From this panel, you can insert one or more sub-queries in the query to form a hierarchical tree and save your queries as a group.

Prerequisites
  • You have accessed Talend DQ Portal as a user.

  • Some queries have already been defined. For further information, see Building a query.

To create different levels in the query tree and save your queries as a group, do the following:

Procedure

  1. In the Query Catalog panel to the right of the Query Editor, select the query under which you want to insert another query and then click the Insert query button on the panel tool bar.

    Example

    A different-level query is inserted under the selected query and an empty query template opens in the Query Editor.

    Example

  2. Follow the procedure outlined in Building a query to define this new sub-query.
  3. Double-click the query under which you want to insert a sub-query, and then click the Insert query button to add as many sub-queries as needed.
    All different-level queries are displayed as a hierarchical tree in the Query Catalog panel. Each query can be a "parent" query of a sub-query at any level of the tree.

    Example

  4. Define the new Query in the Query Editor.
  5. Open the Shortcuts list at the top right corner of the page and select Add to customized views to open a dialog box.

    Example

  6. Enter a name and a description for the query and then select Public or Private from the Scope list.
  7. Click Save to close the dialog box.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!