As you can see in our previous example, Odoo will always use an or operation between each of the conditions you add to the search. But what if we wanted to have a search where the record is active and the sale price is greater than 100? To accomplish this, you must first apply the custom filter with only the active condition defined. This will limit the results to only active products. Then you can go back and add a second custom filter that only contains the Sale Price greater than 100 condition.
Just remember that if you want both conditions to be true, then they must be applied separately. If you want either of the conditions to be true, then add them together in one search:
Advanced search
In the ...
