Skip to Content
Menu
This question has been flagged
1 Odpoveď
4307 Zobrazenia

Hello,

I am performing queries using xmlrpc and i am facing a counter intuitive behaviour :

I try to fetch all the products of my odoo db by doing something like that : 

models.execute_kw(db, uid, password,
'product.product', 'search',
[[]])
and i notice that this query filter out products whose field "active" is set to false.
To retrieve all the products, i have to do something like this : 

models.execute_kw(db, uid, password,
'product.product', 'search',
[[["active", "in", [True, False]]]])


Is this implicit filtering normal ? Where is it documented ? Is there other implicit filterings that i should know about ?


Thanks

Avatar
Zrušiť
Best Answer

Hi,

By default the odoo orm methods return the active records only. In order to get all the records without considering active is True or False, you have to explicitly pass the condition in along with search or pass active_test False in the context.

You can see details here in the odoo documentation: https://www.odoo.com/documentation/14.0/developer/reference/orm.html#

Odoo ORM: https://www.youtube.com/watch?v=8V-uOG8KkKA

Thanks

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
0
jún 21
4563
0
aug 18
4381
1
nov 22
4364
0
máj 23
2244
1
mar 24
5328