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

[Community Alums]

Hello @Kri ,

Try below reference qualifier,

This will show all the records if company field is empty, otherwise will show related records

javascript: if(current.variables.company != "") "active=true^company="+ current.variables.company

This will show all the active record with empty company field if form company field is empty, otherwise will show related records.

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

Regards

Anand