Reference Qualifier for a catalog variable to limit users to a group

andrea_s71
Tera Contributor

Hello all, I am currently working on a record producer with a variable that references the sys_user table. I want the users to be able to select specific group members from an assignment group, and would like to limit the reference field to these group members. In a custom table I was able to achieve the same thing with a script include and an advanced reference qualifier, but it does not work for the record producer, and I do not understand why. It always shows the list of all users.

 

I set the script include to be accessible from all application scopes, as the record producer is in global scope, and even created a script include in global scope in case that was the issue, but it wasn't. 

 

I have included screenshots of the reference qualifier of the variable, and the script include. Appreciate any help.

1 ACCEPTED SOLUTION

GopikaP
Mega Sage

Hi @andrea_s71 ,In the screenshot, I noticed a syntax error. Could you add a full stop after - IsDXOGroupMember() ?

Like this - 

javascript: 'sys_idIN' + new IsDXOGroupMember().getUsers();

 

View solution in original post

3 REPLIES 3

GopikaP
Mega Sage

Hi @andrea_s71 ,In the screenshot, I noticed a syntax error. Could you add a full stop after - IsDXOGroupMember() ?

Like this - 

javascript: 'sys_idIN' + new IsDXOGroupMember().getUsers();

 

I tried that, but it didn't fix the issue. When I use the reference field, it still lists all users from the sys_user table.

Never mind, this pointed me in the right direction. I used a different script include in the global scope with the fixed syntax error, and it's working now. Thanks for the assistance!