Refernce qualifier on Lookup select box

[Martines]

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

[Its_Azar]

Hi there @Martines 

current.variables.leave_type  won’t work directly in the reference qualifier because the variable value is on the client side while the qualifier is evaluated server side.

Try using a catalog client-callable Script Include + AJAX, or use an advanced reference qualifier that receives the variable value through the appropriate variable context.

[Ankur Bawiskar]

@Martines 

please share screenshot of your 2nd variable reference qualifier config how it's applied

how is the 2nd variable's reference table record linked with 1st one?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Martines]

@Ankur Bawiskar  Here is my leave_type variable configuration: 

Here is my leave_type_detail variable configuration

And I'm using script includes to build a query for reference qualifier. 

the u_leave_of_absence table has fields u_leave_category and u_leave_subcategory.  

[Ankur Bawiskar]

@Martines 

did you add log and see if value is coming in script include function?