Help

5

Can we use "AND" in advanced search between two or more condition?

Avatar
Vardan

When we add a condition in advanced search, it use "OR" between the condition. Can we change it to "AND" ?

Avatar
Discard
1 Answer
1
Best Answer

When you want use AND operator, you must simply create a filter for each condition. For example, if you want search a product with name "Open" and category "Erp", you firts search for name open and then for category Erp. So you have an AND filter.

6 Comments
Avatar
Discard
Avatar
Vardan
-

I want to filter the data between two dates. How to do this?

Avatar
Maath
-

You can do it as @Francesco Apruzzese say first filter the date (less than) and then (after the result appear ) you can add new filter (greater than )

Avatar
Vardan
-

Try it.This will not give the output between two dates.

Avatar
Maath
-

why , how it work -is it as or operator or what?- the result should be true try using another field (not date ) Is the method works as and or not?

Avatar
Vardan
-

It seems as you dont know about this. If yes then please have a look first.

Avatar
Maath
-

I have filtered Employees according to Date of Birth put the filter first greater than and then put the filter less than It work perfectly with me

Are you need programming code ? or that is enough to use the interface for the User ?