9 Using Queries

Oracle Data Relationship Management enables you to query nodes in versions and hierarchies based on property values. From the Query task on the Home page, you can create, open, and manage queries. You can open multiple queries in separate tabs, but only one query can be in focus at a time. You can also run queries from a selected data object being browsed.

Within Data Relationship Management, query supports a number of operators such as Like, In, Length Equal, and so on. A list of criteria can be created (similar to the WHERE clause in a conventional SQL statement) that can be run against a set of nodes. The query returns a list of nodes that meet the defined criteria. Queries can comprise multiple criteria that can be grouped together using AND or OR to form complex queries.

Property queries may be saved so users can perform recurring analyses without having to redefine the query criteria each time. The Data Manager can create "standard" queries that are available for use by all other users.

Typical uses of queries:

• Locating nodes that meet certain criteria while browsing hierarchies

• As a filtering mechanism in exports and comparisons

• As the logic for a custom validation used to ensure data integrity