Refernce qualifier on Lookup select box

Martines · 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

Martines · 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();

View solution in original post

yashkamde · 3 weeks ago

you don't need to setup reference qualifier for leave_type variable !

All you have to do is for leave_type_detail variable only..

Martines · 3 weeks ago

Actually I need because in leave_type variable Im filtering options according to value in other field. For example when user is from Brazil I need to display in leave_type options related to Brazil.

Anand__99 · 3 weeks ago

Hi @Martines ,

Your variable qualifier looks good. It should work as expected.

Add a log to your reference qualifier and test if you get any value in logs, verify variable names.

Add a log to your reference qualifier:

javascript&colon; gs.info("lookup " + current.variables.leave_type);

Thanks

Anand

Martines · 3 weeks ago

Hi @Anand__99

I already did that and I got no value in my log.

Anand__99 · 3 weeks ago

Make sure the Value field for the selected choice is not empty.

Troubleshooting Steps:

Open the choice list for the Leave Type field. You can do this by:
- Opening a form of the table, right-clicking the field label (Leave Type), and selecting Show Choice List, then filtering by the table name.
- Alternatively, open the Choices [sys_choice] table and filter by the Table Name and Column Name.
Verify that the Value field for the relevant choice is populated.

Alternative Approach:
Create an onChange Catalog Client Script that executes when the Leave Type variable changes. Use the script to verify whether the selected choice has a valid internal value. You can display an info message or alert with the selected value to confirm that it is being passed correctly.

Thanks

Anand