Hi – I’ve just released an update to the bugzilla reports extension for MediaWiki – see BugzillaReports @ MediaWiki. We use this internally and find it very useful for generating slice and dice reports of our activities. Feel free to give it a try and contact me if you have any questions.
UPDATE: You can report issues or raise enhancements @ http://code.google.com/p/bugzillareports/issues/list
Thanks for your quick response. The filter function works well on my side. I have another question for query, could we define query using Boolean Charts ‘OR’? For example, I want to list all S1 or P1 bugs, is it supported? Thanks again!
You can do an or with a comma, e.g.
{{#bugzilla:priority=P1,P2|sort=severity,status,deadline|status=!(RESOLVED,CLOSED)}}
list all P1 or P2 tickets which are not RESOLVED or CLOSED and sort by severity, status and then deadline.
Ian, that’s not what I want it. I want to list the bugs has P1 priority or critical severity. Current I only know the way to list the bugs had both P1 priority and Critical severity. {{#bugzilla:priority=P1|Severity=critical |status=!(RESOLVED,CLOSED)}}
Echo, OK – currently you can only do that as two separate lists. If you want to see this feature in the future could you raise a ticket @ http://code.google.com/p/bugzillareports/issues/list
Got it. Thanks very much!
Hi,
This is a great application. I was hoping you can help me out with this report I am trying to build using this application. Basically I am trying to get a report which lists the number of bugs each user has logged each day for the last 7 days.
The report would have something like:
Date|Reporter|Bugs Reported
and the values would be something like:
2009-11-11|Joe|3
2009-11-11|Tina|2
2009-11-12|Tina|3
…
Would it be possible to do something like this?
You can achieve something functionally like this with
{{#bugzilla:debug=1|columns=created,from,summary|total=summary|hide=true|debug=1|group=created,from|created=-1m}}
or with explicit list of bugs (instead of just total) as
{{#bugzilla:debug=1|columns=created,from,summary|total=summary|debug=1|group=created,from|created=-1m}}
perhaps not as tidily presented as you suggest, but should allow you to get the data. If you would like to see the report presented in a better way then could you raise a request @ http://code.google.com/p/bugzillareports/
Thanks,
Ian
Hi,
your extension is absolutely great. I have one questin. My input look like:
{{#bugzilla:
|product=IMM_SUP
|status=RESOLVED
|columns=+to,work
|created=XX
|total=work
}}
In created parametr I would like to set only last month. It means, today is 6.1. I would like to see last 6 days.
I have tried this way:
|created=-echo (int)date(d);d
But output look like Parameter created=-6d is invalid using regex /^[\*\w+-:]*$/
Is there any way to set this???
Thanks a lot
Sorry, there was a mistake..:-)
{{#bugzilla:
|product=IMM_SUP
|status=RESOLVED
|columns=+to,work
|created=-echo (int)date(d);d
|total=work
}}
echo (int)date(d); is run by phprun
If you set created explicitly to “-6d” does it work OK for you. I’ve just tested {{#bugzilla:created=-6d}} and it returns the last 6 days. If this does work for you then maybe the report is conflicting with the phprun code.
Currently no way from configuration point of view to disable the validation, but if you want to test things out in the code the validation is done in the BMWExtension.php#extractOptions which gets the validation rules from BSQLQuery.php#getParameterRegex.
By the way the function to display all ticket from this month / last month etc is planned for next release – see http://code.google.com/p/bugzillareports/issues/detail?id=42
HI, thanks for working in this great extension.
I want to do a fairly simple report but cant get it to work.
I just want to display all the bugs that are either RESOLVED, CONFIRMED, OR CLOSED in the last week.
Is there a generic ‘date’ field that you can set to only bring back items within the date range?
Yes – you can do something like …
{{#bugzilla:debug=1|modified=-1w|status=RESOLVED, CONFIRMED,CLOSED|columns=+modified|modifiedformat=date|sort=-modified|}}
(I’ve also added a reverse sort here and included the modified column in the report)