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.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- ลูกค้าสัมพันธ์
- e-Commerce
- ระบบบัญชี
- สินค้าคงคลัง
- PoS
- โปรเจกต์
- MRP
คำถามนี้ถูกตั้งค่าสถานะ
3
ตอบกลับ
34941
มุมมอง
Applying an 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.
Fabrice: thanks for your edit.
Is this the only way? What if I want to look for a customer that has two different tags at the same time? It is easy to type the tag and select "search tag for XXXX", but when adding the second one OpenERP uses an "OR". Doing it with advanced search is totally cumbersome...
Thanks but that behavior is weired. Could be much easier if standard search operator was 'and'.
You can do it by write first condition in search and second condition from custom filter in filter menue
not two from one place
Is there a way to make a second searchbar under the first one that search only for attributs?
สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!
สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!
ลงชื่อ| Related Posts | ตอบกลับ | มุมมอง | กิจกรรม | |
|---|---|---|---|---|
|
Filter last year and last month
แก้ไขแล้ว
|
|
3
ส.ค. 17
|
24435 | |
|
1
ม.ค. 16
|
11722 | ||
|
0
มี.ค. 15
|
5345 | ||
|
1
เม.ย. 24
|
14801 | ||
|
1
มี.ค. 15
|
5575 |
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.
This is the correct way to do it. However the results of filters are not always right.
As far as I can tell, this is currently not functioning! Ack!
edit= False alarm. Apologies. I was searching Public Price and it needed to be Sale Price. Leaving comment for future reference.
Ir works perfectly, but some fields (computed ones) are not searchable.