Search the Community
Showing results for tags 'data partition'.
Found 2 results
Hello SD Masters, I'm working to filter the request areas using organizations with Service Desk 12.7. For that, we want to filter all the areas which it belongs to specifc organization or to the parent organization. For example, if we have an organization named as "Systems - Infrastructure", the parent organization will be "Systems". For that, I create a custom field named "zorganization" into the org object. Everything is ok at this point but when I try to use this field into a data partition with the following constraint: organization is null OR organization = @root.organization OR organization = @root.organization.zorganization I get an error saying "AHD05800:Bad where clause. invalid constraint. @root.organization.zorganization is not a valid @-reference." The idea is an user can only see the request areas belongs to their organization or the previous organization (parent). Do you know why this error is happening? Thank you very much for your support
Hi, Please understand clearly I want to create Data partition for the below requirement 1. I have a user 'User1' assigned to location='location1' 2. I have a user 'location1' assigned to zRegion='2000' I want: If the User1 logged into SDM, he has to see the tickets only which are having Affected end user's zRegion='2000' Example: User1 is assigned to location =location1 location1 user is assigned to zRegion='2000' location2 user is assigned to zRegion='2000' location3 user is assigned to zRegion='2001' location4 user is assigned to zRegion='2002' If User1 is logged in, he has to see the tickets only which are containing Affected end user's zRegion='2000' (two tickets) Note: * zRegion is on cnt as String type. * location1, location2, location3 users are having contact type as 'Store * User1 is assigned to location=location1 in location table. Please help on this. Thanks in advance.