AnsweredAssumed Answered

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

Question asked by e_martin on Jun 6, 2016
Latest reply on Jun 10, 2016 by Chris_Hackett

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

Outcomes