Hi,
Is it possible, in a Record-List page, to filter records based on the user’s role ?
I will try to elaborate a little bit.
Let suppose there are two roles:
- “BasicRole” - members of this role must have RESTRICTED access.
- “PowerfullRole” - members of this role must have UNRESTRICTED access.
In a Record-List page a user, that is member of the “PowerfullRole”, should be able to see all records no matter the record’s owner
on the other hand
a user, that is member of the “BasicRole”, should see only records that belong to it (record.ownedBy=${userID})
I know there are workarounds like - for same module to create two distinct Record-List pages, first page will display filtered records and “BasicRole”'s users would have access here
and second page will display all records and only “PowerfullRole”'s users would be able to access it,
but in this way I will have to duplicate almost all pages (and, of course, later will be a tremendous maintenance effort).
Also, one more question please, except ${recordID}, ${ownerID} and ${userID} there are other variables that could be used into records’ filtering expression?