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.

  Discussion posts and replies are publicly visible

Parents Reply Children