The object ID that acts as an identifier. The query instance is defined for the object.
Query (dmqry0501m000)Use this session to create, edit, print, or view a query. Each query depends on an object defined in ODM. This session enables you to select the object and create a new query for that object. By default, a query string is created for each query. The user can run the query at this stage. Adding object attributes and qualifying them with conditions enhances the query mechanism. All these conditions act as a constraint for that particular query on that object. If you run the query, the results of the objects that satisfy the constraints already given by the user appear. Queries can be of the following types:
In the Query (dmqry0501m000) session, you can group queries by an object. Click Group to browse the required object. You can also enter an object directly by selecting New from the Group menu. To create a new query, click New from the File menu. Specific menu options:
When you run a query, you must store the result set. If you click Yes, the query results are stored and can be retrieved at any point in time. After the query run is complete, you can view the results.
Object The object ID that acts as an identifier. The query instance is defined for the object. Object The name of the object. Query The query ID that acts as the identifier. If object masks have been configured for queries, the query Identifier field is generated automatically according to the mask. Query Description The description of a query. Query Type The types of query. Query can be of the following types:
Created By The creator of the query. Creation Date The creation date and time of the query. Modified By The name of the user who has modified the query. Modification Date The modification date and time of the query. System Defined This is a special option available to define confidential or reusable queries. Marking of this value to true makes the query a system query. Only users with proper authorizations can modify or delete the system queries.
Query Conditions... Defines the conditions of a query. Previous Runs... Displays the previous runs of a query. Execute Query Executes the selected query. On execution, the query results can either be stored or viewed. Native Session Opens the native session on which the current query is based. The records of the native session are filtered based on the conditions specified for the query. Browse Opens the history of the query. Complex Query Conditions Enables you to specify the complex query conditions for a query.
| |||