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

Troubleshooting Object Queries

Troubleshooting Object Queries

I created a query to return objects from a specified folder. The query returned reusable objects. Why?
By default, when you run an object query, the query returns reusable objects that are visible to the current user.
To find both reusable and nonreusable objects in a specified folder, include the Reusable Status parameter and specify reusable and nonreusable values:
The query is: Folder = Vendors AND Reusable Status is one of Non-reusable or Reusable.
I created a query to return objects that use a specified label. The query returned reusable objects that use the specified label. Why?
By default, when you run a query to find objects associated with a label, the query returns labeled reusable objects. To find reusable and nonreusable objects that use a specified label, include the Reusable Status parameter and specify reusable and nonreusable values:
The query is: Folder = Vendors AND Label = Ready_to_Deploy AND Reusable Status is one of Non-reusable or Reusable.
I created a query to search for labeled versioned objects. The query did not return older versions of labeled objects. Why?
By default, when you run a query to find labeled versioned objects, the query returns the latest checked-in version of objects. To find all versions of objects using the specified label, include the Latest Status parameter and specify latest checked-in and older values:
The query is: Folder = Vendors AND Label = Ready_to_Deploy AND Reusable Status is one of Non-reusable or Reusable AND Latest Status is one of Latest Checked-in or Older.
Do I need to edit the query condition after I change the name of a folder or label?
No. After you change the name of a folder or label, the Repository Service retrieves and uses the folder name or the label name in the query condition. The query returns the same results after you rename a folder or label.

0 COMMENTS

We’d like to hear from you!