- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2025 09:29 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2025 11:34 PM
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();
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-13-2025 11:34 PM
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();
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-17-2025 12:24 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-17-2025 12:31 AM
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!