This question has been flagged
2 Replies
33322 Views

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)

Avatar
Discard
Best Answer

'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)
Avatar
Discard
Best Answer

Hi,

you can use :

picking_pool.search(cr, uid, [('sale_id','!=','')], context=context)

Thanks.

Avatar
Discard