Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

2

search method : "is not null" criteria

By
Clément THOMAS
on 5/22/13, 12:42 PM 5,129 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)

1
nazarii
On 5/22/13, 5:04 PM

'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)
1

Borni DHIFI

--Borni DHIFI--
5102
| 6 8 9
Tunis, Tunisia
--Borni DHIFI--

Techno Functional Consultant Odoo(OpenERP) 

http://www.linkedin.com/in/borni

Skype : dhifi.borni

Borni DHIFI
On 5/22/13, 1:08 PM

Hi,

you can use :

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

Thanks.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 5/22/13, 12:42 PM
Seen: 5129 times
Last updated: 8/1/16, 8:30 AM