A customer had the requirement to restrict a field referencing sys_users to only list active users who are members of a specific group.
There is a solution based on the configuration of the standard field in the dictionary:
It is filtering the sys_user reference list depending on the current value of the group field of the current record using an advance reference qualifier with the expression:
This approach could be applied to meet the customers requirement to display only active users that belong to a specific group with sys_id=2d6649bbdbb356004ff5f4331f961924
I suggest in your reference field you use an advanced reference qualifier with the following expression: