How to get groups based on requested for user

[kasturi4]

Hi,

I have a requirement to show only the groups based on the requested_for, I am able to fetch the groups by hardcoding the reference qualifier. The below are details

1. requested_for - reference - sys_user

2. group_name - lookup select box -sys_user_grmember 

Reference qualifier : active=true^user=<sys_id_user>

I tried the ref.qual this wat -> active=true^user=g_form.getValue('requested_for');

Can anyone help on this. 
Thanks in advance!

[Valmik Patil1]

Hello,

Below answer might help you

https://www.servicenow.com/community/developer-forum/show-the-groups-only-where-the-requested-by-is-...

Thanks,

Valmik Patil

[Ratnakar7]

Hi @kasturi4 ,

Please try with below reference qualifier:

javascript : 'user=' + current.requested_for;

Thanks,

Ratnakar

[Chetan Mahajan]

Hi @kasturi4 ,

                          Don't use Active in group member ref qual. as there is no active option its just mapping of users and group. Use Simple ref Qual. on Requested for (Active-is-true) And Advance Ref Qual. on Group Member as below

Kindly mark correct and helpful if applicable

[pjftenorio]

This is working but it returns sys_id of Groups. How do I convert this to Display Value of Groups?

v