Using a Lookup in the Filter to check two different fields in the NSQL Portlet

[Legacy User]

For our Project Object, we have an IT Work Manager field and a Backup IT Work Manager field. While pulling in this data with NSQL for a grid Portlet, I want the user to be able to put in data without needing to power filter, for one user, and have it return results if they're present in either the IT Work Manager field or the Backup IT Work Manager field. Mainly because if they were to populate both options with the same person, it's going to return results where the user entered is BOTH the IT Work Manager and Backup IT Work Manager not independent of each other.

 

Project A has X as an IT Work Manager, and Y as the Backup IT Work Manager

Project B has Y as an IT Work Manager, and Z as the Backup IT Work Manager

 

I want to be able to filter the work efforts for Project Manager Y and have it return Project A & B

[Deactivated User]

Add something like

( (@WHERE:PARAM:USER_DEF:STRING:w_mgr@ = ODF_CA_PORJECT.IT_Work_Manager or   @WHERE:PARAM:USER_DEF:STRING:w_mgr@ = ODF_CA_PORJECT.IT_BU_Work_Manager) OR   @WHERE:PARAM:USER_DEF:STRING:w_mgr@ is NULL)

 

to your NSQL  query and associate pararm_w_mgr with RESOURCE_SCH_BROWSE lookup using the ID field.

[System]

Hi Eric - Did Martti's response help answer your question? If so please mark as Correct Answer. Thanks!