Re: How to search for unset boolean property

it depends on the database backend. For example PostgreSQL and MySQL supports "IS NULL" operator for queries.


> Ralf Schlatterbeck <[email protected]> hat am 17.04.2024 09:43 CEST geschrieben:
> 
>  
> 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]
> 
> 
> _______________________________________________
> Roundup-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/roundup-devel