OR over multiple columns

rohit99

I am trying to achieve 'OR over multiple columns'. I have Firstname, Lastname and phone columns. I want to do a search filter like this : (Firstname AND Lastname ) OR (phone). Can anyone help me with this ?

allan

Two options:

1. Use a regex search with the | (OR) character in the expression - search() has details (note you can't use columns().search() here - it searches across the columns and all much match).
2. Use a custom filter which will give you complete control over what is shown and what is not.

Allan

rohit99

we need work on two different columns like this : 1st column Name and 2nd phone number

allan

What I said above still applies - your either need to create a suitable regular expression or use a custom filter.

Allan

rohit99

we have need to search in multiple column at the same time. Like: [Other_except] = "True" or [FLOWDOWN_YES] = "True"

allan

Going to close this thread as your other on this topic is a duplicate.

Allan