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:
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:
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.