On Jun 3, 2:10 pm, Lukasz Szybalski <[email protected]> wrote: > On Jun 2, 3:54 pm, Lukasz Szybalski <[email protected]> wrote: > > > > > Hello, > > I'm trying to get management reports for the following: > > > 1. Count Incoming tickets by milestone sort by date, (30 new tickets > > for milestone on 06-02-09).... > > 2. Count closed tickets by milestone and user. (25 tickets closed by > > xyz on 6-2-09)(list a count by user in each milestone) > > 3. lookup by custom field? (custom field = account_number) (With query > > I can do that, but how do I put it on a wiki so that they can type in > > account# and press "query" or something along these lines.) > > > Where can I find examples on how to do this? > > > I've noticed on the website trac seem to want to replace the "reports" > > with "query". Would anybody have a "query syntax" for all the default > > reports that I can paste into wiki page? > > > This for example allows me to modify the new tickets by milestone: > > [query:status=new|assigned|reopened&version=1.0 Active tickets against 1.0] > > > But with the other reports most of them ask for action, and/or count > > on particular category or action. How many tickets we had, how many > > closed, who closed most of them, how many are outstanding, who is > > doing most of the work,etc? > > Anybody knows how can I display: > > user , ticket count in a table? > > The only thing I was able to do is on a wiki page do: > > Users Assigned Tickets: > 1. admin : [[TicketQuery(status=assigned&owner=admin, count)]] > > But this way I need to list every user manually. Is there a way to > display all users? > user1, 5 > user2, 55 > user3, 10 > ...... > > I can also link to custom query if that is easier... > > 2. How can I query by date? All new tickets today by milestone? (this > would include new, accepted, fixed,..etc)? > > Ideas? > > Thanks, > Lucas
Couple options actually. The Opteros folks have some plugins for their OForge project that does some of this. a sql report can be created to do this. (there is a created date or similiar field you could compare to the current date/time) there is a plugin to display an sql query in a table and probably others. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
