Re: How to search for unset boolean property

Ralf Schlatterbeck <[email protected]> Wed, 17 Apr 2024 09:43:10 +0200
Newsgroups gmane.comp.bug-tracking.roundup.devel
Message-ID <[email protected]>
On Tue, Apr 16, 2024 at 07:42:07PM -0400, John P. Rouillard wrote:
> Hi all:
> 
> Boolean properties in Roundup can have three values: true, false and unset.
> 
> For link/multilink we can find unset properties by searching for '-1'.
> 
> For searching a boolean property, 0/1 finds false/true values. But how
> to find unset?
>
> Anybody with an answer or ideas how to do this?

Do you mean in the current implementation of how it should look like in
a new implementation?
For the current implementation I think you cannot query for None (aka
NULL in sql).
For a new implementation I like the idea of using -1 there, too.

Thanks
Ralf
-- 
Dr. Ralf Schlatterbeck                  Tel:   +43/2243/26465-16
Open Source Consulting                  www:   www.runtux.com
Reichergasse 131, A-3411 Weidling       email: [email protected]