Advanced Reference Qualifier Not Working on Catalog Item ESC

[sna12578]

Hi

Having an issue with my Advanced Reference Qualifier.

I have 2 tables called Function / Sub-Function. Sub-Function references Function.

Sub-Function table:

I have created 2 variables of type: Reference.
Function:

Sub-Function:

I'm trying to filter out Sub-Function values based on what I have in Function. However I have tried variations of the advanced reference qualifier and instead of filtering it out, it keeps on showing me the full list. 



Based on the function variable, it will match it based on the u_parent field in the u_sub_function, Finance = Finance and it will give me the values I need. I tried hardcoding by:

javascript:'u_parent=6a96d5d73b5bb29040c5f49a04e45a53'

where the ID is the sys_id of Finance and this one works. What could I be missing? Help is appreciated. Thank you.

[Ankur Bawiskar]

@sna12578 

function variable referring to which table?

share screenshots of that table

Also since variable is reference type no requirement of ref_qual_elements, remove that

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

[sna12578]

Hi,

Function:

Sub-Function:

Function Variable:

Sub-Function Variable: