Filtering - "contains" does not work like I would expect it to

[bryanc78]

When I use the "contains" filter, I'm expecting to pull in results if any of the words are listed in my criteria but that is not the case

For example, I have 3 contacts:

1. Miami Warehouse
2. Miami Warehouse Phoenix
3. Miami Closed Warehouse

If I do Owner contains Warehouse, all 3 records are retrieved.

If I do Owner contains Miami Warehouse, the 3rd is not retrieved.  I'm assuming because warehouse is not the 2nd word.

So this to me, is broken. My search criteria, Miami Closed Warehouse does contain the words Miami Warehouse.

This an issue or working as intended

[SN_Learn]

Hi @bryanc78 ,

If I will copy the query, it will show:

nameLIKEMiami Warehouse

This mean it is searching for 'Miami Warehouse' together in the name field and could only find 2 in which this piece of word is consecutive. It is considering the value as a single keyword and searching it in the whole string.

Operators available for filters and queries 

Mark this as Helpful / Accept the Solution if this helps

[AndersBGS · Accepted solution]

Hi @bryanc78 ,

This is working as intended. You're searching a string contains "Miami Warehouse" not contains "Miami" and "Warehouse". 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[bryanc78]

Thank you everyone.

[SN_Learn]

Hi @bryanc78 ,

Could you please also accept my reply as solution if that helped?

You can mark multiple answers as correct, Thanks