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.
Hello,
Both the Function and Sub-Function variables are type: Reference. Yes there's values for the u_sub_function table. Table snippet where it references u_function table in u_parent field
With the filter I added onto the post, it gives me ALL the values from u_sub_function table, it doesn't filter out based on the u_parent field.
Hello @sna12578 ,
As per your requirement I tried in my instance so its working fine :
Having 2 variables : 1) Caller (manager),
2) Users (user's under that manager)
Added that into catalog item as per your Function (caller) & Sub-Function(users) :
As a result getting filtered out users which are having the caller as manager :
Plz check some mistakes such as semicolon - after advanced javascript qualifier or fields backend value !
If my response helped mark as helpful and accept the solution.
Hi,
Thanks for checking. This is the exact thing I'm currently doing in my tables, however it's not working. The values are still showing the FULL list, it's not getting filtered at all. I've compared my set-up to yours which is working and from my view, everything looks the same, except the field names of course. So perplexed as to where it's going wrong
