On Jun 3, 3:34 pm, yoheeb <[email protected]> wrote:
> 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
I would probably try the sql version. I've noticed there is a button
that saves you custom query which says:
"Query for Report: (can be either SQL or, if starting with query:, a
TracQuery expression)"
Is SQL supported out of box? What would be a sample sql syntax that I
could use with: Trac: 0.11.1
What would the sql statement look like for the custom query, something
that says:
select milestone, count(*) , from ?? group by milestone, created
date.
and the second query
select user, milestone, count(*) , from ?? where status = fixed group
by user, milestone, closeddate
Sample syntax? What is the table name? What columns have create date,
and fixed date?
Thanks,
Lucas
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
