Active=true in Reference Qualifier

[Kri]

I want to add additional condition active=true in my existing script in the reference qualifier for the Variable 'Line Manager', I tried adding the below script but it is not working, Can you help me where I'm going wrong?

javascript: "company=" +current.variables.company^active=true

[Hayo Lubbers]

Hi,

active=true is part of the string (no javascript variable), so similar to company= and should be quoted. This should work:

javascript:"active=true^company="+current.variables.company

otherwise this works:

javascript:"company="+current.variables.company+"^active=true"

[Kri]

Both the script didn't works, it should show empty value if Company value is not selected, Once Company value selected it should show only its related records in Line Manager currently it is showing all records

[Karan Chhabra6]

Hi @Kri ,

Try with this reference qualifier

javascript: if(current.variables.company) 'active=true^company='+current.variables.company; else 'sys_idISEMPTY';

If my answer has helped with your question, please mark it as helpful and correct

Thanks!

[Kri]

it is not working, it is showing all the records