グループに紐づくロールを参照・選択/Browse and select roles associated with the group

[NaoyaT]

ご教示いただけますと幸いです。

参照フィールドでグループを選択すると、そのグループに紐づいているロールをリストコレクタフィールドで選択できるようにする方法はありますでしょうか。

また、リストコレクタフィールドでロールを選択すると、日付で表示されてしまうためロール名で表示したいのですが、
ロールテーブル側の表示設定ではなく、カタログUIポリシーやカタログクライアントスクリプト等で実装したいと考えております。(ロールテーブルがOOTBのため。)

-------------

We would appreciate it if you could enlighten us.

Is there a way to select a group in the reference field so that the roles associated with that group can be selected in the list collector field?

Also, when I select a role in the list collector field, it is displayed by date and I would like to display it by role name,
We would like to implement this in a catalog UI policy, catalog client script, etc., rather than in the display settings on the role table side.

[NaoyaT]

@Ankur Bawiskar 

Sorry for the delay in replying. Thank you also for your instruction on how to respond.

I understood the following as you presented.
The role name should be displayed when selecting by referring to sys_user_role.
Create an object (gr), and in sys_group_has_role, acquire the role associated with the group acquired by crrent.variables.
The acquired values are returned to the filter by array processing.

When I actually tried to set up the filter, the filter for sys_user_role was not functioning properly.
Is it because the value obtained in “current.variables.groupVariableName” is sys_id?

[Ankur Bawiskar]

@NaoyaT 

1st variable is referring to group table (sys_user_group)

2nd variable is referring to sys_user_role either as reference or list collector type

when you do current.variables.groupVariable you will get sysId as it's a reference variable pointing to group table

If my response helped please mark it correct and close the thread so that it benefits future readers.

[NaoyaT]

@Ankur Bawiskar 

Thank you very much.

I have set up the script you provided and was able to display only the roles associated with the selected group by role name.

The final result is as follows.

javascript:

var query;
var gr = new GlideRecord('sys_group_has_role');
gr.addQuery('group',current.variables.groupVariableName);
gr.query();

var arr = [];

while (gr.next()) {
   arr.push(gr.getValue('role'));
}
query = 'sys_idIN' + arr.join(",");
query;