QBE Line and Query Management

You can use the query-by-example (QBE) line to define or refine the data to include in your data selection. For example, if your preview includes multiple companies and you want to include the data for one company only, you can enter the company number in the QBE line and display only the records for the specified company. When you click the View button, the system includes only the records for the specified company in the data that you can view in the Project Status Inquiry form. You can enter values in the QBE line before you first click Preview to limit the data that the program displays in the grid.

You can use the Query Management function to save search criteria for the grid. If you save an enhanced query, you can populate the grid with data that meets the query data. For example, if you create and save an enhanced query that includes a company number and specify to use that query as a default value, then the Work with Project Status Inquiry form initializes with the data for the specified company number when you click the Preview button.

See "Queries" in the JD Edwards EnterpriseOne Tools Using and Approving User Defined Objects Guide.