| To define a query |  |
| You can use SQL queries to extract information from the database and present this information in a report or chart. To define a query, complete these steps: Step 1. Specify basic query properties Start the Query Data (ttadv3580m000) session. Click New. The Query Data (ttadv3180s000) details session starts. 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 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 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. 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: Start the Query Data (ttadv3580m000) session. Select the query and, on the specific 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 To add query table fields to a chart. You can now run the query. See To run a query. Related topics To define a query with Easy SQL To define a query with the Text Manager To add query table fields to a chart To run a query The ERP LN SQL section in the ERP LN 6.1 Programmer's Guide |