support SREL joins in @root/@cnt references in Data Partition constraints and stored queries

Idea created by Michael Mueller Employee on Nov 3, 2016
    Not planned
    Score33

    View constraints are a perfect way to partition data depending on attributes of the logged in user using @root references

    For example a view constraint on call requests, which looks like:

    customer.location=@root.location

    would grant view access to call requests where the location of the affected user is equal to the location of the logged in user.

     

    Unfortunately, the capability of @root references is restricted to direct attributes of the contact record.

    That means it is not possible to use a dotted attribute notation(srel's) for @root references.

    Based on the example above, it may make sense to grant access to call_requests, where the site of the location of the affected user is equal to the site of the location of the logged in user.

    This could look like:

    customer.location.site=@root.location.site

    But is not supported currently.

     

    The same restriction can be observed for @cnt references when creating stored queries.

    Also here it would be usefull to be able to use dotted notation(srel joins) to be more flexible and more generic when creating stored queries.

     

    Based on this community question Data Partition Query on Call_Req from Balram.Deswal