Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 359613

Summary: Support querying for empty values
Product: z_Archived Reporter: Sam Davis <sam.davis>
Component: MylynAssignee: Mylyn Inbox <mylyn-inbox>
Status: RESOLVED NOT_ECLIPSE QA Contact: Frank Becker <eclipse>
Severity: normal    
Priority: P3    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Whiteboard:
Attachments:
Description Flags
query none

Description Sam Davis CLA 2011-09-30 15:54:39 EDT
Using boolean charts, I can't directly query for an empty value. For example, if I want to find bugs where the blocks field is empty, I have to use a query like _does not match regexp "."_. I should be able to say _is equal to ""_.
Comment 2 Sam Davis CLA 2011-10-03 13:24:28 EDT
Created attachment 204461 [details]
query

If I do the query shown, I get bug 358554 in the results. I don't think I should get that task because its blocks field is not empty. I also think it would improve clarity if there were an "is empty" option in the boolean charts, but "is equal to" the empty string should work too.
Comment 3 Frank Becker CLA 2011-10-03 14:25:32 EDT
(In reply to comment #2)
> Created attachment 204461 [details]
> query
> 
> If I do the query shown, I get bug 358554 in the results. I don't think I
> should get that task because its blocks field is not empty. I also think it
> would improve clarity if there were an "is empty" option in the boolean charts,
> but "is equal to" the empty string should work too.

If you use the Bugzilla Search Page you get the same result.

https://bugs.eclipse.org/bugs/buglist.cgi?query_format=advanced;short_desc=extensible;field0-0-0=blocked;short_desc_type=allwordssubstr;type0-0-0=equals;component=Framework;product=Mylyn%20Tasks

Mylyn use 

https://bugs.eclipse.org/bugs/buglist.cgi?query_format=advanced&short_desc=extensible&field0-0-0=blocked&short_desc_type=allwordssubstr&type0-0-0=equals&value0-0-0=&component=Framework&classification=Mylyn&product=Mylyn%20Tasks

but this generate the same result.

So I see no way how we can fix this.
Comment 4 Sam Davis CLA 2011-10-03 15:59:30 EDT
I guess this is a limitation of Bugzilla then. Perhaps the search button should be disabled if the value is blank, if it is not meaningful to search for blank values? That might depend on the kind of search being done though (e.g. equal, regexp).
Comment 5 Frank Becker CLA 2011-10-03 16:07:09 EDT
(In reply to comment #4)
> I guess this is a limitation of Bugzilla then. Perhaps the search button should
> be disabled if the value is blank, if it is not meaningful to search for blank
> values? That might depend on the kind of search being done though (e.g. equal,
> regexp).

OK I can look how we can do this!

But I think we should fill an bug against bugzilla to solve this.
Comment 6 Sam Davis CLA 2011-10-03 17:06:44 EDT
Thanks Frank. It looks like this has already been reported against Bugzilla: 
345194: Add "is null" and "is not null" search operators to the boolean chart (ability to search for empty and not empty fields)
https://bugzilla.mozilla.org/show_bug.cgi?id=345194