Odoo 11 - Python module search

Question

I'm trying to retrieve from script all the product published except for one category, this method is invoked by an automadet action. The code is:

The issue is that the search is returning all the product template, not only the website_published = true, can anyone help to understand the issue in the code?

Thank you.

Begineer · Accepted Answer

Hi,
Try giving the reverse way,  ('website_published', '!=', False)
The domain inside the search normally uses the AND operation , you need not mention *and *in between your conditions. You can simply give a " comma", [('website_published', '!=', False), ('public_categ_ids', 'not in', (7)]. This is just for your information.
I guess the domain fails due to your second condition, i guess  public_categ_ids is a many2many field so try giving as above
Hope it helps.

Filippo · Answer

Thank you a lot, it worked fine!

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Python Code for automated action python code AutomatedActions	0 helmik. 24	2667
How to do compare ignoring case in search filter? Ratkaistu filter code search	1 marrask. 22	14843
ORM .browse method returns objects even if the ids do not exist on the database Ratkaistu python code orm	2 heinäk. 22	6488
automated action python code strange behaviour Ratkaistu python search AutomatedActions	1 marrask. 20	3393
How to get current id? python search odoo9	1 marrask. 17	4830

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!