Defining a query

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.

To define a query:

Fase 1. Specify basic query properties
  1. Start the Query Data (ttadv3580m000) session.
  2. Click Nuevo. 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.
Fase 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.

Fase 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 Vistas, Referencias o Acciones menu, select Generate Query Report.
Fase 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.

Temas relacionados