Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 359613 - Support querying for empty values
Summary: Support querying for empty values
Status: RESOLVED NOT_ECLIPSE
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Mylyn (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows 7
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Mylyn Inbox CLA
QA Contact: Frank Becker CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-30 15:54 EDT by Sam Davis CLA
Modified: 2011-10-03 17:06 EDT (History)
0 users

See Also:


Attachments
query (44.39 KB, image/png)
2011-10-03 13:24 EDT, Sam Davis CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
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