Hi All, I need a before query business rule that checks for a group membership of the currently logged-in User and returns some filtered/queried records from the sys_user_group table (having u_hidden value as true)?

[Koushik Ningara]

Need a before Query business rule which checks for a group membership of the currently logged-in User and returns some filtered records from sys_user_group table having field value Hidden=true.

[Musab Rasheed]

Try something like this and tweak accordingly. mark my answer as correct or hit like.

[Koushik Ningara]

That assignment group is "External Vendors", should I add in-place of current.assignment_group??

[Musab Rasheed]

@Koushik Ningaraju : Yes, add in single quotes and your condition in encoded query, it will work, no need for gliderecord as well , Mark my answer as correct or hit like based on impact

[Koushik Ningara]

Thanks bro...Tanvi Jain, Jyoti p dalvi........all left this team. It's been very hard without proper mentors.