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

Hello,


I am working with a Boolean field in Odoo and trying to use it in a group-by operation. However, I noticed that when the field is NULL in the database, Odoo automatically treats it as `False` when grouping records.


Expected Behavior:

-True → Grouped as "True"

- False → Grouped as "False"

- NULL (Undefined) → Should be grouped as "Undefined"


### Actual Behavior:

True → Grouped as "True"

False → Grouped as "False"

NULL → Also grouped as "False" instead of "Undefined"


It seems like Odoo's ORM considers `NULL` as `False`, which causes all uninitialized records to appear in the "No" group.


My Questions:

1. How can I make Odoo show an "Undefined" category for NULL values in a Boolean field?

2. Is there a built-in way to handle this in the ORM or do I need a computed field?

3. Any best practices for handling Boolean fields in grouping?


I am using **Odoo11 Enterprise**.


Any help would be appreciated. Thanks!


Avatar
Zrušiť
Autor

But I am able to store NULL, True, and False values in the database. Why can't we display this in Odoo's group-by UI?

Because we do not support null booleans (the are always False). This was a design decision because only very technical Users understand null AND there is no way to display NULL to Users.

Autor

yeah! thanks for your confirmation Ray!

Best Answer

Odoo does not support null booleans (they are always False).

You will need another field type.

Boolean by definition has two values: True and False.

You are asking for three values which is not an Odoo boolean field type.


Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
1
apr 21
3942
2
júl 21
6204
1
jan 20
4920
5
dec 18
28616
3
jan 23
29436