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. Appendix A: MX Views Reference
  17. Appendix B: PowerCenter Reports Reference

Repository Guide

Repository Guide

Configuring Query Conditions

Configuring Query Conditions

Each query condition consists of a parameter, an operator, and a value. You can add, cut, copy, paste, and move query conditions. Each time you add a query parameter, you specify an operator and a value. You can view the valid operators and values for each parameter when you add the parameter to a query.
You may need to configure multiple query conditions to effectively narrow the results. Use the AND and OR logical operators to add multiple query conditions. For example, you might want to deploy a group of objects with the Deployment_2 label, but you also want to ensure that the objects were saved after a particular date.
When the Repository Service processes a parameter with multiple conditions, it processes them in the order you enter them. To receive expected results and improve performance, enter parameters in the order you want them to run.
If you nest several parameters within a query, the Repository Service resolves each inner parameter conditions before outer parameter conditions.
For example, when you run the following query with nested conditions, the Repository Service resolves the innermost conditions and the next outer conditions until it resolves all parameter conditions. The query shows the order in which the Repository Service resolves query conditions:
The query is ((Label = X AND Folder = Y) AND (Comments = X OR Deployment = Y)) AND (Object Name contains X AND Check-in Time is greater than Y). Label is an example of an innermost condition. The AND that joins Label and Folder is outside Label. Check-in Time is an example of a parameter that is further outside, followed by the AND that joins Check-In Time and Object Name. The AND that joins the two main phrases of the condition is the outermost condition.

0 COMMENTS

We’d like to hear from you!