I’m working with the User table. I’ve extended it to have an column entitled “Title” that is an Object Array. The Array has the following columns “Active Role”, “Role ID”, “Role Description” , “Start Date”, and “End Date”. This is a listing of roles that a user can have depending on the date. For example, the User might be in the AEE role and the ISR role for the first 6 months of the year and then the AEE role and the BDR role for the remainder. Easy enough - select the boolean value int he Active Role column and modify the Start and End dates appropriately.
Now I am trying to query the User table and build constraints or WHERE clause to only bring me back the User who has a specific Title ID=, User ID and Active Role=true. It seems to be working except that I cannot get the Active Role=true to filter out the records whre the array is false.
It’s easier to see what I am trying to do by reviewing the image I’ve included. Any help would be appreciated. Regards, Kevin
