BROWSE_PROJMGR not working as expected in Manager attribute

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

'Manager' attribute, unlike other attributes based on 'BROWSE_PROJMGR' lookup, does not behave the same in the Classic than in the Modern UX.

Steps to Reproduce

1. Modify Browse Resource (id = BROWSE_PROJMG) to a unique name, like 'Browse Resource Empty'.
2. Modify the lookup query with an impossible condition (such as adding 'AND 1 = 0').
3. Preview the results for the lookup - no results should be returned.
4. On Studio, check that Investment, Project, Idea... all use 'Browse Resource Empty' for Manager and Target Manager (for the objects where it exists).
5. Go to the Classic UX Ideas and add 'Manager' and 'Target Manager' to the List View.
6. Check the values for both lookups - no values will be returned.
7. Go to the Modern UX Ideas and add 'Manager' and 'Target Manager' to the Grid.
8. Check the values for both lookups.

Expected Results: Both 'Manager' and 'Target Manager' do not return any values when expanded.

Actual Results: 'Target Manager' does not return any values when expanded (expected), but 'Manager' returns the same values as before the changes.

Environment

15.7.1 and higher

Cause

This was analyzed by Engineering and Product Management under DE64297.

Resolution

The Modern UX is working as expected, it is using a different system-restricted lookup.

The Project Object, Manager Attribute uses the 'BROWSE_PROJMGR' Lookup. This lookup is defined as System-Type = 'User-defined'. This means the Query can be modified. Classic will continue to use this lookup as defined in Studio on the Project Object.

The API /describe/projects uses the 'BROWSE_PROJMGR_NAME_ONLY' Lookup. This lookup is defined as System-Type = 'System-restricted'. This means the Query cannot be modified . The API & Modern UX will use this lookup instead of the lookup defined in Studio on the Project Object. The new lookup was created to improve performance in the Modern UX.

On the Idea Object, the 'Target Manager' Attribute uses the 'BROWSE_PROJMGR' Lookup in both Classic and Modern UX.

Additional Information

If changes made in "Attribute Suggestion List Display" section of BROWSE_PROJMGR_NAME_ONLY lookup is not reflecting correctly in the Modern UX, try creating a dummy custom attribute in the Project object, that refers to this lookup. Then check if changes made to this section start showing against the "Manager" attribute or not. The custom attribute can be deleted after testing.