sys_group_has_role in list collector variable

[NaoyaT]

We would appreciate your help.

When I reference sys_group_has_role.list in the list collector variable, it shows the date the role was created.
If this is all, it is possible to display the role name at the same time by the attributes of the variable, but when I select a role, it is displayed only by date.
If there is a way to display by role name, I would appreciate it if you could please let me know.

[senon · Accepted solution]

A straightforward solution is to set the "Role" field in [sys_group_has_role] as the Display Value.

When setting values for reference fields or variables, the field displayed is the one where the Display Value is marked as True.

In the screenshots below, which are taken from my Personal Development Instance (PDI), all Display Values are set to False.

Therefore, in the following example, the SysID appears as the Display Value. (Please note that these screenshots show how the catalog is displayed in the platform interface, not on the portal. The appearance of the variable you configured may differ. However, rest assured, this variable is a List Collector referencing sys_group_has_role.)

Next, I set the Display Value of the "Role" field in sys_group_has_role to True.

As a result, the role names should now be displayed.

Please note that this change will affect the display value of all fields and variables referencing [sys_group_has_role].

best regard.

[NaoyaT]

@senon 

Thank you for your response.

I understood that the display setting of sys_group_has_role determines which items are referenced in the table.

Let me ask an additional question.
I understand that the display values of all fields and variables referenced by sys_group_has_role are affected. Is there a way to investigate the affected display values at once? Or do I need to check them one by one?

Also, what is the impact on the displayed values of the fields and variables?

[senon]

(おそらく日本の方だと思うので日本語も併記しますね)

Display valueは、他のフィールドから参照されるときに表示されるレコードの表示値を設定することができます。つまり影響範囲を調査する場合は、[sys_group_has_role]を参照するフィールドもしくはカタログ変数が存在しないかを検索する必要があると思います。

フィールドであればDictionary Entriesテーブル[sys_dictionary]にアクセスし、参照先が[sys_group_has_role]を参照しているフィールドを探すのはいかがでしょうか？

変数も同様にして見つけ出すことができると思います。

--- ENG ---

The Display Value setting determines the display value of a record when it is referenced by other fields. Therefore, when investigating the scope of impact, it is advisable to search for fields or catalog variables that reference [sys_group_has_role].

For fields, you might consider accessing the Dictionary Entries table [sys_dictionary] to find fields that reference [sys_group_has_role].

Similarly, catalog variables can also be located using a similar approach.

[NaoyaT]

@seno 

お心遣いいただきありがとうございます。日本人です！

ご回答いただきありがとうございます。

参照している側のテーブルにて、参照先がsys_group_has_roleとなっているレコードを確認すれば、影響範囲が調査できると理解しました。

弊社環境にて確認したところ、sys_dictionaryテーブル、item_option_new(変数)テーブルともに参照先がsys_group_has_roleのレコードが無いことが確認できたので、影響はないと判断ができそうです。

ありがとうございました。

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

Thank you for your consideration. Japanese!

Thank you for your answer.
I understood that we can investigate the scope of impact by checking the records in the referenced tables that have sys_group_has_role as the reference.

When we checked in our environment, we were able to confirm that there were no records in the sys_dictionary table and the item_option_new (variable) table with a reference to sys_group_has_role, so I think we can conclude that there is no impact.

Thank you very much.