Question
Data filtering based on user access
Scenario is need to filter the data based upon user access to certain business unit id,forum id.Business unit id's are different sectors of business and they are mapped to certain forum id's.Business unit can have duplicate forum id's.
they are stored in table like
| user id | bu id | forum id |
| 117 | 4 | 80 |
| 117 | 4 | 103 |
| 117 | 4 | 114 |
| 117 | 19 | 80 |
19 also has records with 103,114 forum id but we need records on the above mapping but when we try to filter it out by querying and storing in a local variable not able to filter out records for mapping of(19-114,19-103).
local!buid(filter:userid),
local!forumid(filter:userid,buid),
In a interface we are using a record type in data and in filter we are using logical expressions.