Advance reference qualifier

[shivani18]

ISSUE WITH ADVANCE REFERENCE QUALIFIER

Created Advanced Reference Qualifier in Catalog Item (with variables 'group' and 'assigned')

to fetch values of users only of selected group.

But this is not working

Needed help to solve this.

[Sandeep Rajput]

@shivani18 Your Advanced reference qualifier seems correct. However, the table you have selected seems incorrect. Instead of choosing User[sys_user] table you should choose Group Member[sys_user_grmember] table as the assignment group field exists on Group Member table and not on User table.

Please mark the answer helpful and correct if it manages to address your issue.

[shivani18]

Hello @Sandeep Rajput 

Thank you for replying !!

I modified the table name as you suggested.

But still many records it is fetching (other than members of the group) and it is now fetching sys_id, 

instead of name of user.

[Sandeep Rajput · Accepted solution]

@shivani18 Please modify the reference qualifier as follows.

replace assignment_group with group in your reference qualifier.

Regarding sys_id display, please make the following change in the Group Member table.

[shivani18]

Hello @Sandeep Rajput ,

I updated reference qualifier and sys_user_grmember table as you suggested above

But still it is providing same results