How can I add "One of My Group Members" using Business Rules.

[ayano]

I want to add choice Opened by is (dynamic) "One Of my Group Members" below.

However, I couldn't add there.

Now, this is the Business Rule that I created.

Script is below.

function groupMembers(grpName) {
var mbrs = new Array();
var grmember = new GlideRecord('sys_user_grmember');
grmember.addQuery('group.name', grpName);
grmember.query();
while (grmember.next()) {
mbrs.push(grmember.user.toString());
}
return mbrs;
}

And also, this is the Dynamic Filter Options that I created.

Then, it's got into Open by Groups, not into Opened by.

How should I make it?

[Willem]

It does not take the 'grpName' in the Dynamic filter. If you change that to:

groupMembers()

And your script to:

function groupMembers() {
    var grpName = gs.getUser().getMyGroups();
    var mbrs = new Array();
    var grmember = new GlideRecord('sys_user_grmember');
    grmember.addQuery('group', 'IN', grpName);
    grmember.query();
    while (grmember.next()) {
        mbrs.push(grmember.user.toString());
    }
    return mbrs;
}

It should return all users that are in one of your groups.

Can you try that and let me know?

[ayano]

Thank you for the reply.

I changed that you taught me but it's still display in "Opened by group" is (dynamic) One of My Group Members.

I'd like to display "Opened by" is (dynamic) One of My Group Members.

[Willem · Accepted solution]

Hi,

On the Dynamic Filter Option change the Reference table from:

Group [sys_user_group]

To:

User[sys_user]

[ayano]

Thank you for the reply.

I changed that you taught me but it's still display in "Opened by group" is (dynamic) One of My Group Members.

I'd like to display "Opened by" is (dynamic) One of My Group Members.