Contact - address field

[wtconseil]

Hi

i'd like to search contacts that match multiple zipcode (ex: 75000, 92000)...

So, trying to get all contacts from 75% department, and 92% department but i don't find the good syntax

I tried that but it doesn't match

Thanks for your trick !

[tanya]

Hi

For now it is possible only with Reports feature from Advanced Pack. OR operator isn't supported here

[wtconseil]

That's so bad ...
i think we shoudl have this working with "is like (%)"

I don't understand how to use this.. and we put a regexp or something like this ?
any examples ?

thanks

[tanya]

You can filter contacts in two steps
- postal code starts with 75
- postal code starts with 92
But no way together

[wtconseil]

Yep i know .. but that's not user friendly.

Do you have some examples about how to use "is like (%)" filter ?
which synthax is expected with that filter?

[tanya]

you can use LIKE wildcards ('%', '_')

[wtconseil]

doesn't work with parenthesis.. :-(

[tanya]

in parenthesis were 2 wildcards, it was just description

[wtconseil]

would it be possible to have an easy example ?
With field: zipcode i have rows with data like that : (75000, 92000)...

I'd like to search all contacts with zipcode "75%" or "92%"

[tanya]

You can filter contacts in two steps
- postal code starts with 75
- postal code starts with 92
But no way together

In search panel is using an operation AND

If you don't want use option "Starts with" and want to use only "Is Like", set a filter '%92___%' for address field or '92%' filter in postal code. In case using option 'Starts with' - '92' is enought

[wtconseil]

Do you think it could be complicated to adjust these filter to have the possibility to set a Regular Expression ?
Something like ^(92|75)*