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!

[Basheer]

Hi @kasturi4 ,

There wouldn't be any field by name active in sys_user_grmember. If you try placing it in the reference qualifier it may result in wrong values sometimes.

As you've already mapped group_name to sys_user_grmember below is the reference qualifier which you can use

javascript&colon;"user="+current.variables.requested_for;

If the field is present in the variable set then use below

javascript&colon;"user="+current.variablesetname.variables.requested_for;