Defining a query (OP)

In an on-premises environment, you can create stand-alone queries with Easy SQL or with the Text Manager. Easy SQL helps users to define queries in a simple, menu-driven way. Text Manager enables you to create more complex queries.

The functionality to define and run stand-alone SQL queries is not available in a cloud environment.

To define a query:

Step 1. Specify basic query properties
  1. Start the Query Data (ttadv3580m000) session.
  2. Click New. The Query Data (ttadv3180s000) details session starts.
  3. Specify the basic properties of the query, such as the owner and the output type. Select one of the following output types:
    • Report list
    • Report label
    • Chart
  4. To return to the Query Data (ttadv3580m000) overview session, click Save and Close.
Step 2. Define the selection criteria for the query

To define the selection criteria for the query, you can use:

  • Easy SQL

    Easy SQL helps users with insufficient knowledge of the structure of the data model to define queries in a simple, menu-driven way. See Defining a query with Easy SQL (OP).

  • The Text Manager

    You can use the Text Manager to create more complex queries. See Defining a query with the Text Manager (OP).

    You can also use the Text Manager to modify queries that were previously defined with Easy SQL.

Step 3. Optionally, generate the query report

Complete this step only if you selected Output Type Report list or Report label.

To generate the query report, complete the following steps:

  1. Start the Query Data (ttadv3580m000) session.
  2. Select the query and, on the appropriate menu, select Generate Query Report.
Step 4. Optionally, add query table fields to a chart

Complete this step only if you selected Output Type Chart.

See Adding query table fields to a chart (OP).

You can now run the query. See Running a query (OP).

Related topics