- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-21-2019 03:24 PM
I have a catalog item with two reference variables on it and I need to make the available values on the second variable based on the value selected on the first variable. I wrote a script include for the reference qualifier but I'm having trouble passing the value of the 1st reference variable to the 2nd's reference qualifier. Can anyone help me with the proper syntax?
Tables:
sys_user - has the user's department as a field
u_divisions - has a list of divisions that belong to a particular department.
1st reference qualifier: requested_for based on the sys_user table
2nd reference qualifier: I want all divisions in the same department as the requested_for's department.
Solved! Go to Solution.
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-21-2019 03:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-21-2019 03:29 PM
Should be current.variables.requested_for
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-21-2019 03:38 PM
Ah! I feel foolish now! Thanks, that was the correct answer.