跳至內容
選單
此問題已被標幟
1 回覆
837 瀏覽次數

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!


頭像
捨棄
作者

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.

作者

yeah! thanks for your confirmation Ray!

最佳答案

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.


頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
1
4月 21
3930
2
7月 21
6202
1
1月 20
4914
5
12月 18
28604
3
1月 23
29430