Reference qualifier with multiple fields

[Geeky]

I have a reference field pointing to table B on table A. On table A and B I have Company field.

When user Opens a form to submit a record on table A, they see a reference field of table B.

Now that reference field should have two qualifiers active = true and Company = company of table A.

How can I do this? 

[Geeky · Accepted solution]

Just single line helped me from this link

https://community.servicenow.com/community?id=community_question&sys_id=0a4a87a9db5cdbc01dcaf3231f96...

[Somasekar]

Hi,

Go to the dictionary of the field and configure the reference field

Please use Advanced Reference qualifier with below Query :

javascript: active = true^company = current.company

the add the dictionary attribute : ref_ac_columns=company

Mark helpful if it is..

Regard,

Somasekar C

AELUM Consulting.

[kente]

You could just use a single line reference

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