Advanced reference qualifier for requested for groups list using Sys_user_group table.

Ram050670
Tera Guru

‎10-03-2023 10:42 AM

Hi, i am looking to pull list of groups (Type= request)  of a requested for in a drop down field using sys_user_group table. 

can someone help me with the advanced refernce qualifier.

 

0 Helpfuls
  • 767 Views
3 REPLIES 3

Cobee
Tera Expert

‎10-03-2023 11:09 AM

I trick I use is to set the condition in the "Use Reference Qualifier" section to Simple, then build the condition using the condition builder. Then click save on the page. Once saved, change the "Use Reference Qualifier" to advanced and it will provide you with the advanced script. 

Cobee_0-1696356518142.png

 

Cobee_1-1696356533851.png

 



0 Helpfuls

Ram050670
Tera Guru
In response to Cobee

‎10-03-2023 11:25 AM

How do you get the users group list then?

i think you have not understood my question.

 

i have a reference field and on the SP i want to show the list of groups the requested for is in.

 

0 Helpfuls

Cobee
Tera Expert

‎10-03-2023 11:40 AM

Ahh yes. Apologies. You can set the reference field to look at sys_user_group, which will show all the groups available. There might be a way to set the values of this list based on the current requested for as a dependent. Check under the "Auto-populate" tab under the variable to play with the dot-walking. 

0 Helpfuls