Red Hat Bugzilla – Bug 498418
Boolean Query: Enable (time) snap shot based queries
Last modified: 2013-06-23 22:22:05 EDT
Description of problem:
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.
reported upstream https://bugzilla.mozilla.org/show_bug.cgi?id=477595
Could i get some feedback with regards to the difficultly and feasibility of this request?
I think the Series Charts are supposed to be address this but it is not exported through any other interface except for the web UI. For information on series charts see:
As for the query.cgi UI, mostly works off current state of bugs in the database since it directly converts the criteria to SQL. The bugs changes section of query.cgi is accessing the activity table but as you mentioned it only looks for activity entries that occurred in a date range so it missed any bug hits that were already in the state you are looking for before the range you specify.
I am not sure what upstream will say regarding this.
Yea, looks like the 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. Do you think such a feature would be difficult to implement? Upstream has so far given me no response.
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.
Red Hat Bugzilla is now using version 3.4 of the Bugzilla codebase and
therefore this feature will need to be implemented against the new release.
Updating bug version to 3.2.
Red Hat has now upgraded to Bugzilla 3.6 and this bug will now be reassigned to that version. It would be helpful to the Bugzilla Development Team if this bug is verified to still be an issue with the latest version. If it is no longer an issue, then feel free to close, otherwise please comment that it is still a problem and we will try to address the issue as soon as we can.
Bugzilla Development Team
i'm working an outside of bugzilla solution to this as we speak. Closing.