Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
846 Lượt xem

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!


Ảnh đại diện
Huỷ bỏ
Tác giả

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.

Tác giả

yeah! thanks for your confirmation Ray!

Câu trả lời hay nhất

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.


Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 4 21
3941
2
thg 7 21
6203
1
thg 1 20
4918
5
thg 12 18
28615
3
thg 1 23
29434