Advanced Reference Qualifier - Multiple Conditions

[Chris_Wilkinson]

Hi

Does anyone know how to combine these two conditions for use as an advanced reference qualifier?

javascript: 'u_country=' + current.variables.select_tip_entity_country_for_this_request 

u_new_entity_id ===

Thanks

Chris

[Allen Andreas]

Hi,

Is this an "AND" query or "OR"?

If AND:

javascript:'u_country='+current.variables.select_tip_entity_country_for_this_request+"^u_new_entity_id="+current.variables.field_name;

if OR:

javascript:'u_country='+current.variables.select_tip_entity_country_for_this_request+"^ORu_new_entity_id="+current.variables.field_name;

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Allen Andreas]

Hi,

I'm glad you found a correct answer.

I had hoped my initial reply and my follow-on reply below, that included deep explanation, screenshots, etc., would be what helped guide you Correctly.

Take care!

[Chris_Wilkinson]

Hi Allen, 

Thanks for the reply. It's an AND query that is supposed to carry out a lookup on the entity table for the country (this is a variable on the form) but only return records from the entity table where country matches and the field 'new entity' is not empty.

Hopefully that makes sense.

Cheers

Chris

[Abhijit4 · Accepted solution]

Hi Chris,

In that case you can try below,

javascript:'u_country='+current.variables.select_tip_entity_country_for_this_request+"^u_new_entity_idISNOTEMPTY";

Let me know if you have any further queries.

Please mark this as Correct or Helpful if it helps.

Thanks and Regards,
Abhijit