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 · ‎02-08-2022

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.

Meera11 · ‎02-08-2022

if(gs.getUser().isMemberOf(current.assignment_group)){

var gr = new GlideRecord("sys_user_group");

gr.addEncodedQuery("u_hidden=true") // copy query link from sys_user_group_table

gr.query();

{

add remaining logic

}

Mark Correct/ helpful if this helped you

View solution in original post

Koushik Ningara · ‎02-09-2022

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