User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:220.127.116.11) Gecko/2009020410 Fedora/3.0.6-1.fc9 Firefox/3.0.6 Build Identifier: I need a way to search for 'all bugs of a specified product that were OPEN (ie, were NOT CLOSED) at a particular snapshot of time,' eg. Product: Firefox, OPEN on 2008-01-01. I know how to get this information for TODAY (ie, now()). A simple boolean search like the one below does it: Product::equals::Fedora & Version::equals::Rawhide & bug_status::notequals::CLOSED But I want to know the same information for a day other than 'now'. Some how i need to be able to say product::equals::FireFox & bug_status::notequals::CLOSED 'on' 2008-01-01 I'm trying to avoid having to use SQL to get this information, as i only have access to XML-RPC interface. I believe Boolean Chart queries should have this functionality. The 'changedafter/changedbefore' options don't work for this case. I would /greatly/ appreciate an answer to this question / feature implemented to make it possible. Without it, it's hard to gather certain metrics about the state of bugzilla's in the past. Reproducible: Always
Summary: Boolean Query → Boolean Query: search for sates in a particular snapshot of time
Summary: Boolean Query: search for sates in a particular snapshot of time → Boolean Query: search for states in a particular snapshot of time
Could someone confirm whether this request will be worked on or not? Thanks!
For metric gathering purposes, it would be terribly useful if one could query bugzilla based on snapshots in time (day granularity) using standard boolean queries (webui and xmlrpc). For example, i would like to know exactly how many FutureFeatures there were on 2009-01-01 (23:59), which also meet an arbitrary number of other query criteria. Today it is possible to query bugs which 'changed to FutureFeature' on 2009-01-01. But this doesn't account for bugs the way i would like to, as it only finds the bugs that actually 'changed to', ignore those which were already FutureFeature. IOW I want to know the total number of FutureFeature bugs on 2009-01-01 (at 23:59), irrespective of there state the day before or the day after. Effectively, this would be equivalent of me 'going back in time' and making the given boolean query request at 23:59 on 2009-01-01.
when i say FutureFeature, i'm using that as an arbitrary Keyword in this instance
Looks like the new chart reporting might help me map the data i want. However, I would still prefer the flexibility of being able to query the data using xmlrpc, to map it using my own implemented plot system. Is such a feature difficult to implement? I envision being about to query bugzilla exactly the same way i do today, using boolean queries, but there being an additional field called 'on_day', which accepts a past date and returns results as they would have been if the search was made on the date specified in 'on_day' field.
Valid request. See also bug 380878.
Status: UNCONFIRMED → NEW
Ever confirmed: true
See Also: → bug 380878
You need to log in before you can comment on or make changes to this bug.