Bug 498418

Summary:	Boolean Query: Enable (time) snap shot based queries
Product:	[Community] Bugzilla	Reporter:	Chris Ward <cward>
Component:	Query/Bug List	Assignee:	PnT DevOps Devs <hss-ied-bugs>
Status:	CLOSED NOTABUG	QA Contact:
Severity:	medium	Docs Contact:
Priority:	low
Version:	3.6	CC:	dkl
Target Milestone:	---	Keywords:	FutureFeature
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Enhancement
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-08-27 10:23:18 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Chris Ward 2009-04-30 12:22:16 UTC

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.

Comment 1 Chris Ward 2009-04-30 12:27:15 UTC

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?

Comment 2 David Lawrence 2009-05-01 20:50:52 UTC

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:

http://www.bugzilla.org/docs/tip/en/html/reporting.html 

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.

Dave

Comment 3 Chris Ward 2009-05-04 07:28:27 UTC

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.

Comment 4 David Lawrence 2010-01-15 17:32:26 UTC

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.

Comment 5 David Lawrence 2010-08-25 21:42:47 UTC

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.

Thanks
Bugzilla Development Team

Comment 6 Chris Ward 2010-08-27 10:23:18 UTC

i'm working an outside of bugzilla solution to this as we speak. Closing.