Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. MX Views Reference
  17. PowerCenter Reports Reference

Repository Guide

Repository Guide

Object Queries Overview

Object Queries Overview

An object query is a global object that you use to search for repository objects that meet specified conditions. When you run a query, the repository returns results based on those conditions. You can run an object query to locate versioned and non-versioned objects. You can run an object query from the Designer, Workflow Manager, or Repository Manager.
You can create an object query to complete the following tasks:
  • Find and maintain object relationships.
    Use object queries to locate parent and child dependencies, shortcut dependencies, and primary and foreign key relationships.
  • Find groups of invalidated objects to validate
    . Use a query to locate invalidated objects.
  • Associate a query with a deployment group
    . When you create a dynamic deployment group, you can associate an object query with it.
  • Track versioned objects during development
    . You can add Label, User, Last saved, or Comments parameters to queries to track versioned objects during development.
  • Find deleted versioned objects to recover
    .
To create and run an object query, you configure the query conditions and run the query. Each query condition consists of a parameter, an operator, and a value. You can add, cut, copy, paste, and move query conditions. When you run the query, the Repository Service queries the repository and displays the results in the Query Results window.
You can create queries in the Repository Manager or through the pmrep CreateQuery command.

0 COMMENTS

We’d like to hear from you!