Riddle me this: Using RBS value for Custom Report

[TGG]

To all,

SCENARIO
We use the RBS to restrict which projects appear in the Project Center
views. One of our developers is creating a pipeline report in a
reporting tool so that it can be printed. This report is running
directly against the database.

PROBLEM
Currently the pipeline report prints every project. We are adding the
grouping and filtering capability. However, our initial
ungrouped/unfiltered printout should match the RBS restricted Project
Center view.

WHAT'S NEEDED
A method to perform dynamic filtering on RBS value just as is done in
PWA.

Any help or suggestions is sincerely appreciated.

Thanks!
--Treb

 

[David Gage - Project MVP]

The actual values for outline code IDs are stored in MSP_CODE_FIELDS. Using
the outline code ID, you can find the code in MSP_OUTLINE_CODES. You have a
few options for possible filtering; use the parent/child codes or use the
full name of the outline code.