How to make "Assign to" dependent on "Assignment Group" in a record producer?

[Cory Miller1]

We want to limit the user list under "Assigned to" on a record producer based on the selected "Assignment Group"...

[Gaurav Shirsat]

Hello

Could you please check the  Thread 

Please Check this and Let me know, whether you have found solution

Please Mark Correct and Helpful
Thanks and Regards
Gaurav Shirsat

[Steven Parker]

I believe you may be overcomplicating this.

Field Name - Assignment Group

Assignment Group - Reference to table sys_user_group

Field Name - Assigned To

Assigned To - Reference to table sys_user_grmember

Advanced Reference Qualifier - javascript:'group='+current.variables.assignment_group

current.variables.assignment_group is the name of my Assignment Group variable

Now once you do that, the Assigned To field on the Record Producer will be filtered by the Assignment Group field as shown below.  You can then configure the list layout in the Group Members window to show the fields you want users to see:

[Neil5]

This is an interesting solution. Definitely the simplest one that i see.

Although i tried it but the list shows "created" instead of the user itself. It also fill the variable as the date. Any idea?

[Steven Parker]

Sure....2 things:

First - On your Assigned To field, which you click the search icon and get the popup, you can change the list layout to display what fields you want to show in the popup:

Second - Go to the sys_user_grmember table (sys_user_grmember.list in the filter navigator/search box), right click one of the column headers and Configure -> Table.  Click on the User column, check "Display Value" box, and update.

[uma mane]

Hello 

I also want to do above requirement and i have done it on my instance but i just want list collector type instead of reference for assigned to variable. How would i do it. for list collector its not working.

it worked for refence type.