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

[Jorge17]

Hi Abhijit,

I need assistance. I want to hide all groups that are not active. So you tell how I can add "active=true" to reference qualifier in advanced section. 

javascript: var refQual = getAssgnGrps(current.variables.assignment_group_search_finder); refQual += '^nameNOT LIKEBL-'; refQual;

Thank you for your assistance,

Jorge

[Jorge17]

Hi Abhijit,

I forgot to provide a screen shot of it.

[Allen Andreas]

Hi Chris,

Feel free to give full details like that in your original reply. So beyond the "AND" and "OR" question...you had more details to share which changes things (now the field is to be empty). I tried my best to cover both scenarios as an example, but it seems without the added information, you weren't able to take it from there.

The best way for you to learn is to go to the list view of records in question, filter it as close to how you want it to be. Then, right-click the last piece of the breadcrumb trail and choose "copy query", then you can start to build out your query from there.

Example:

Which results in:

caller_idISEMPTY

Then, you can take that and use my "AND" example and go from there. This means, don't forget to use the up carrot ^ so that the query means "AND".

We'd love for you to learn. Give it a shot!

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

[Chris_Wilkinson]

Hi Allan, 

Thanks for the assist. I didn't realise I could build the query and export it to see what it contains, this will be really helpful for the future. Looking back I agree my original question could have been better worded 🙂 Every time I post here I learn a little bit more.

Warm Regards

Chris