How can I use AND operator in advanced filters in OpenERP 7? If I want search a date range, I obtain always the OR operator and i can't change it.
Can you confirm it works for V7, namely for the online version? With my standard online database I cannot obtain any filtered results with numerical values (prices, costs etc); Is ther a (coming) documentation on filters. I have more than 2000 products! it is therefore essential to be able to filter efficiently.
OR or an
AND operator in your filter is done in 2 different ways:
- Open the Advanced Search panel, select a criteria, then click on 'Add a condition' to add a second one (do not hit enter or close the filters window), then click on 'Apply'. An
ORoperator will be applied between those 2 filters.
- Open the Advanced Search panel, select a criteria, click on 'Apply'. Open the Advanced Search panel again, select another criteria, click on 'Apply'. An
ANDoperator will be applied between those 2 filters.
In OpenERP 7, the
OR operator is part of the same ticker while the
AND operator creates 2 separate tickers. The screenshot below shows the difference: the list displays the opportunities that are from the country Canada or China on the one hand, and that have an expected closing date greater than 12/09/2012 on the other hand.