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
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
Instead of doing all this go with Record security. It's the easy way around i guess