How can I search for bugs without a deadline?

I noticed that there are lots of ways I can search for bugs that D have a
deadline, such as using an advanced search using boolean charts and testing
for "deadline" "contains regexp", and "[0-9]", but checking "not" on the
search results in zero bugs found.

Also, is there a way that I can require that all bugs have a valid deadline
in them?



support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

Can someone please TRY to help!?!?


"Mike Lyons" <bz (AT) spongysoft (DOT) comwrote in message
@mozilla.org
>I noticed that there are lots of ways I can search for bugs that D have a
>deadline, such as using an advanced search using boolean charts and testing
>for "deadline" "contains regexp", and "[0-9]", but checking "not" on the
>search results in zero bugs found.
>
Also, is there a way that I can require that all bugs have a valid
deadline in them?




support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

Mike,

Not an expert here or anything but you sounded like you need something right
quick.
Try this:

select b.bug_id
from bugs.bugs b
where b.deadline is null



Message
From: support-bugzilla-bounces (AT) lists (DOT) mozilla.org
[@lists.mozilla.org] Behalf Mike Lyons
Sent: Monday, July 09, 2007 2:38 PM
To: support-bugzilla (AT) lists (DOT) mozilla.org
Subject: Re: Please Help!!! How can I search for bugs without a deadline?

Can someone please TRY to help!?!?


"Mike Lyons" <bz (AT) spongysoft (DOT) comwrote in message
@mozilla.org
>I noticed that there are lots of ways I can search for bugs that D
>have a deadline, such as using an advanced search using boolean charts
>and testing for "deadline" "contains regexp", and "[0-9]", but checking
>"not" on the search results in zero bugs found.
>
Also, is there a way that I can require that all bugs have a valid
deadline in them?




support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you
reply.

support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

Can I do that in bugzilla? That looks more like a mysql statement.

"Robert Long" <RLong (AT) atonesoftware (DOT) comwrote in message
@lists.mozilla.org
Mike,

Not an expert here or anything but you sounded like you need something right
quick.
Try this:

select b.bug_id
from bugs.bugs b
where b.deadline is null



Message
From: support-bugzilla-bounces (AT) lists (DOT) mozilla.org
[@lists.mozilla.org] Behalf Mike Lyons
Sent: Monday, July 09, 2007 2:38 PM
To: support-bugzilla (AT) lists (DOT) mozilla.org
Subject: Re: Please Help!!! How can I search for bugs without a deadline?

Can someone please TRY to help!?!?


"Mike Lyons" <bz (AT) spongysoft (DOT) comwrote in message
@mozilla.org
>I noticed that there are lots of ways I can search for bugs that D
>have a deadline, such as using an advanced search using boolean charts
>and testing for "deadline" "contains regexp", and "[0-9]", but checking
>"not" on the search results in zero bugs found.
>
Also, is there a way that I can require that all bugs have a valid
deadline in them?
>



support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you
reply.



support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

It is a MySQL statement indeed, intended audience is the bugs database.
The shortest distance between two points

An expert perhaps unlike myself can point another way via the front end but
it sounded like you had no time to wait?



Message
From: support-bugzilla-bounces (AT) lists (DOT) mozilla.org
[@lists.mozilla.org] Behalf Mike Lyons
Sent: Monday, July 09, 2007 3:52 PM
To: support-bugzilla (AT) lists (DOT) mozilla.org
Subject: Re: Please Help!!! How can I search for bugs without a deadline?

Can I do that in bugzilla? That looks more like a mysql statement.

"Robert Long" <RLong (AT) atonesoftware (DOT) comwrote in message
@lists.mozilla.org
Mike,

Not an expert here or anything but you sounded like you need something right
quick.
Try this:

select b.bug_id
from bugs.bugs b
where b.deadline is null



Message
From: support-bugzilla-bounces (AT) lists (DOT) mozilla.org
[@lists.mozilla.org] Behalf Mike Lyons
Sent: Monday, July 09, 2007 2:38 PM
To: support-bugzilla (AT) lists (DOT) mozilla.org
Subject: Re: Please Help!!! How can I search for bugs without a deadline?

Can someone please TRY to help!?!?


"Mike Lyons" <bz (AT) spongysoft (DOT) comwrote in message
@mozilla.org
>I noticed that there are lots of ways I can search for bugs that D
>have a deadline, such as using an advanced search using boolean charts
>and testing for "deadline" "contains regexp", and "[0-9]", but checking
>"not" on the search results in zero bugs found.
>
Also, is there a way that I can require that all bugs have a valid
deadline in them?
>



support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you
reply.



support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you
reply.

support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

Thanks for the help, Robert, I appreciate it.

Yeah, this would work for mysql (which I'm not really using directly'm
trying to just use the bugzilla web front end). If I just wanted the bugs,
too, I could create a front-end query ignoring the deadline, and include the
deadline column in the output, and then sort on deadline.

But I'd like to make a saved query that just reports bugs without a deadline
so I can easily go in and fix them.

Ideally, I'd really like to restrict users from being able to enter bugs
without a valid deadline.



support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

Have you tried using the Boolean charts?

I set the search field to 'Deadline', the expression to 'equal to' and
left the criteria field blank. It seemed to pick up bugs without a
deadline (which in my case is all of them).

Message
From: support-bugzilla-bounces (AT) lists (DOT) mozilla.org
[@lists.mozilla.org] Behalf Mike
Lyons
Sent: Tuesday, 10 July 2007 9:27 AM
To: support-bugzilla (AT) lists (DOT) mozilla.org
Subject: Re: Please Help!!! How can I search for bugs without a
deadline?

Thanks for the help, Robert, I appreciate it.

Yeah, this would work for mysql (which I'm not really using
directly'm
trying to just use the bugzilla web front end). If I just wanted the
bugs,
too, I could create a front-end query ignoring the deadline, and include
the
deadline column in the output, and then sort on deadline.

But I'd like to make a saved query that just reports bugs without a
deadline
so I can easily go in and fix them.

Ideally, I'd really like to restrict users from being able to enter bugs

without a valid deadline.



support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you
reply.


This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.

support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

Yes, I did.

Doing what you suggest ALWAYS returns ALL bugs, even those that have a
deadline, which is not what I want.

Thanks for the suggestion, though.

"Lee, Jarrad ()" <ja.lee (AT) logicacmg (DOT) comwrote in message
@lists.mozilla.org
Have you tried using the Boolean charts?

I set the search field to 'Deadline', the expression to 'equal to' and
left the criteria field blank. It seemed to pick up bugs without a
deadline (which in my case is all of them).




support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

Actually I take that back, it looks like search will only look at non
null values it could be useful if it did though - as you're finding
here.

I did an update on bugs though and set the deadline to 0000-00-00 where
it was null, then searched on that - terrible solution but it works.
Problem is future bugs will still go in as null unless you enter
0000-00-00 as the deadline

Message
From: support-bugzilla-bounces (AT) lists (DOT) mozilla.org
[@lists.mozilla.org] Behalf Lee,
Jarrad ()
Sent: Tuesday, 10 July 2007 10:14 AM
To: support-bugzilla (AT) lists (DOT) mozilla.org
Subject: RE: Please Help!!! How can I search for bugs without a
deadline?

Have you tried using the Boolean charts?

I set the search field to 'Deadline', the expression to 'equal to' and
left the criteria field blank. It seemed to pick up bugs without a
deadline (which in my case is all of them).

Message
From: support-bugzilla-bounces (AT) lists (DOT) mozilla.org
[@lists.mozilla.org] Behalf Mike
Lyons
Sent: Tuesday, 10 July 2007 9:27 AM
To: support-bugzilla (AT) lists (DOT) mozilla.org
Subject: Re: Please Help!!! How can I search for bugs without a
deadline?

Thanks for the help, Robert, I appreciate it.

Yeah, this would work for mysql (which I'm not really using
directly'm
trying to just use the bugzilla web front end). If I just wanted the
bugs,
too, I could create a front-end query ignoring the deadline, and include
the
deadline column in the output, and then sort on deadline.

But I'd like to make a saved query that just reports bugs without a
deadline
so I can easily go in and fix them.

Ideally, I'd really like to restrict users from being able to enter bugs

without a valid deadline.



support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you
reply.


This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be
copied, disclosed to, retained or used by, any other party. If you are
not an intended recipient then please promptly delete this e-mail and
any attachment and all copies and inform the sender. Thank you.

support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you
reply.

support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

This issue is addressed in Bugzilla's own bug database as Bug 345194 - add a "is null" item in the boolean chart. Go to bugzilla.mozilla.org and search for "345194". There is a patch that you can use there, which will allow you to search for null values in the Deadline field. At the time I am writing this post, the patch has not yet been accepted into the official build, so go and vote for it, so that it gets the attention of the people in charge.