- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
HI community,
I have record producer with two variables. Leave type and Leave type detail. Both of them are look up select box type.
When I choose value from Leave type I want that reference qualifier will filter leave type detail options according the Leave type value. but when I paste into reference qualifier current.variables.leave_type i got nothing.
Do you have any idea why I got no value in current.variables.leave_type ? Thank you for help
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
I found a solution. The problem was that on a leave_type variable I have Look up value field as SYS_ID. In the backend this field is a choice type field. So I changed the SYS_IS value to backend name of the field which is u_leave_category. Then in my leave_type_detail variable I can receive value from current.variables.toString();
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Yes I did, and for current.variables.leave_type I got no value in my script include.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
you need to debug step by step
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Thank you for your answer. Do you have any tips how to debug this? I only added gs.info to my script include to see if some value or error is coming from my ref qualifier. But when I look into the log I see message with no value, nothing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hello @Martines ,
These can be achieved by simple lookup select box configuration fetching values from custom table :
First create one variable (Select Box) name Leave Type and setting as follows:
One Variable (Lookup Select Box) name Leave Type Detail and setting as follows:
Then in one custom table add two of your fields (choice) - leave type and detail and values as follows :
Then you will get the result as per your requirement :
If my response helped mark as helpful and accept the solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Thank you for your response.
I cannot have type select box for leave_type variable, because I need to put there reference qualifier for that field.
