How to call search method with "is not null" criteria :
picking_pool.search(cr, uid, [('sale_id','is not','null')], context=context)
(I know that's not the good syntax)
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
2
Replies
37059
Views
'is not null' is not correct operator for using search method. List of operators you might use: =, !=, >, >=, <, <=, like, ilike, in, not in, child_of, parent_left, parent_right. to get you code working try this:
picking_pool.search(cr, uid, [('sale_id','!=',False)], context=context)
Hi,
you can use :
picking_pool.search(cr, uid, [('sale_id','!=','')], context=context)
Thanks.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Dec 23
|
20980 | ||
|
8
Jul 24
|
16417 | ||
|
Using search count
Solved
|
|
2
Dec 23
|
20077 | |
|
0
Mar 15
|
8521 | ||
|
1
Mar 15
|
7270 |
