Filter a group reference field to only get the groups of a selected user

[Emmanuelck]

Hello Everyone!

I have a task that requires me to filter a group reference field to only get the groups of a selected user. I believe I tried every possible solution, and got close many times. 

I user the advance reference qualifier of the group field, as well as a client callable script include. 

Here is my script include:

 

I do not think there is any issues with it, I'll explain why later.

Here is the Reference qualifier of the group field:

(CODE: javascript:new u_getUserGroups().getGroups(g_form.getValue('requested_for')) )

The result is unfortunately an Unfiltered list:

I think the issue is coming from the Reference qualifier, because if I use a hard coded sys_is string (for user andrew.jackson), I do get the right filter:

Here is the Reference qualifier with hard coded string:

 

And here is the result:

Would anyone know why it doesnt work with g_form.getValue?

Any help would be greatly appreciated!

 

[Asif Khan M · Accepted solution]

Hi,

Can you try using javascript:new u_getUserGroups().getGroups(current.variables.requested_for) ?

[Emmanuelck]

That was it! Thanks a lot Asif.