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 

since variable is reference type no need of ref_qual_elements, remove that

[sna12578]

Hi, 

Even after removing the variable attributes ref_qual_elements, issue is still not resolved.

[sna12578]

Duplicate reply, removed

[rajshinde999910]

Hi @sna12578 ,
Which table both the fields are referring?

[sna12578]

Hi,

Function:

Sub-Function: