how to exclude values in advanced search?

dexcampos

Hello,
I'm trying to show all contacts that are not in a specific city? How can I do that in the Advanced Search in the record browser? Is it possible?

I already tried these strings in the city column but did not get any result:
1. !Bangkok
2. !=Bangkok
3. NOT Bangkok

If the above is not possible how can I only select those contacts with no City instead?

Thanks in advance!

ajb

Hi,

as I know there is no such option built in. If you just want to do this once and you can write simple code in PHP using custom crits.

To get all companies where city value isn't "bangkok" (NOT "bangkok", "Bangkok", " Bangkok XYZ") - use below crits.

$crits = array('!~city' => '%bangkok%');

To get all companies without city set use below crits.

$crits = array('city' => '');

And here how to get companies records.

Utils_RecordBrowserCommon::get_records('company', $crits);

Regards,
Adam

dexcampos

Thanks Adam!

It worked!

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge