AnsweredAssumed Answered

Help with a Data Partition constraint

Question asked by ddorben on Oct 18, 2017
Latest reply on Dec 2, 2017 by ddorben

Hello, i am stuck trying to write a data partition constraint that will allow me to restrict users from only viewing tickets that are assigned to their ORG. Currently right now we are doing this by group with the following.

Call_Req NOT (group.last_name IN ('GroupName)

 

I would like to accomplish this by Organization not by Group due to the number of groups that we have I have tried the following but its not working

 

Call_Req NOT (organization.org_num IN ('ORGName')

 

any suggestions? 

Outcomes