Defining a query

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.

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

To define a query:

  1. Specify basic query properties
    1. Start the 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.
  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 To define a query with Easy SQL.

    • The Text Manager

      You can use the Text Manager to create more complex queries. See To define a query with the Text Manager.

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

  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.
  4. Optionally, add query table fields to a chart

    Complete this step only if you selected Output Type Chart.

    See To add query table fields to a chart.

You can now run the query. See To run a query.