Clarity

I'm creating an attribute and I want the lookup to be able to search for all active resources.  When I look at other OOTB attributes in PPM, they have different resource browse lookups selected.  Which one do I use?  Or do I use a different one that I don't have listed?

1. Browse Resource - ID: BROWSE_PROJMGR

2. Browse Resource - ID: BROWSE_PROJMGR_LT

3. Resource Browse - ID: LOOKUP_FIN_PLAN_RESOURCES

4. Resource Browse - ID: SCH_BROWSE_RESOURCE

If you look at the query of the SCH_BROWSE_RESOURCE lookup, it looks for active resources:

SELECT @SELECT:RESOURCES.ID:ID@,
                @SELECT:RESOURCES.LAST_NAME:LAST_NAME@,
                @SELECT:RESOURCES.FIRST_NAME:FIRST_NAME@,
                @SELECT:RESOURCES.FULL_NAME:FULL_NAME@,
                @SELECT:RESOURCES.UNIQUE_NAME:UNIQUE_NAME@,
                @SELECT:RESOURCES.UNIQUE_NAME:UNIQUE_CODE@
                FROM SRM_RESOURCES RESOURCES               WHERE
                @WHERE:SECURITY:RESOURCE:RESOURCES.ID@               AND
                @FILTER@               AND RESOURCES.PERSON_TYPE != 0                             
                @BROWSE-ONLY:
               AND     RESOURCES.IS_ACTIVE = 1
               :BROWSE-ONLY@

Regards

NJ

Eventually you are better of if you study each of those to see what is the query used and what does it return and further what are the hidden and display keys. That will be good in the long run.

Sometimes it is not the Resource Browse you need but User Browse.

Further options are Browse Resource and Browse User and even Stakeholders.

Thanks NJ.  I am looking for a query that bring back active users.

Garrett