콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다

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
3935
2
7월 21
6203
1
1월 20
4916
5
12월 18
28612
3
1월 23
29433