Ritm visibility using assignment group and parent group

[jobin1]

Hi All

Need to get the below 3 values in Query BR how it can be achieve?

1. How we can get the current logged in user assignment group and its parent group in query BR?

2.How all Ritm group and its parent group can be get from Query BR.

3. If 1 and 2 are same(both condition returns same value) then those Ritms should only visible to logged in user

[Murthy Ch]

Hi jobin,

Give this a try:

(function executeRule(current, previous /*null when async*/ ) {

    //var a = new global.ArrayUtil().convertArray(gs.getUser().getMyGroups());
    var arr = [];
    var arr1 = [];
    var grG = new GlideRecord("sys_user_grmember");
    grG.addQuery("user", gs.getUserID());
    grG.query();
    while (grG.next()) {
        arr.push(grG.getValue("group"));
    }
    var grA = new GlideRecord("sys_user_group");
    grA.addQuery("parent", "IN", arr.toString());
    grA.query();
    while (grA.next()) {
        arr1.push(grA.getUniqueValue());
    }
    current.addQuery("assignment_group", "IN", arr.toString() + arr1.toString());

})(current, previous);

[jobin1]

@Murthy Chintalapudi  No Murthy its not working.

[Murthy Ch]

Hi,

Do you want to show the child group RITM's if that user is a part of parent group of its child group?

If yes then above should work I tested in my PDI and its working.

Please share screenshots if not working 

[jobin1]

@Murthy Chintalapudi that user is part of parent group but not part of his child group

[Murthy Ch]

Correct. I got your point, the above code takes the logged IN user groups and it will check the parent field in group table and it takes all the child groups