Search for multiple values in a text field filter

💬 General Discussion
1

Hello there,

I was looking for a way to look up multiple records in the text field based on multiple values.

For example I am looking for 2 leads:
one with the mail: example1@example.com
two with the mail: example2@example.com

is there a syntax like :

example1@example.com | example2@example.com

or syntax like

example1@example.com OR example2@example.com

that I could use for doing such search?

(I could just go to the database… but it would be easier if that feature already exists)

Version 7.10.4
Sugar Version 6.5.25 (Build 344)

2

Sorry, I don’t think this exists. You could probably tweak the code in the Search box to allow some SQL, but normally this is all bullet-proof restricted so that people don’t try injection attacks from the search box :frowning:

3

Instead of search you have to use a report. You can put multiple conditions and use and/or operators

See example condition for accounts whose name starts with A or B:

1 Like