Hmm, I hadn't thought of making my own macro to do that. I may give that a shot, thanks.
On Monday, April 29, 2013 4:43:30 AM UTC-4, Cooke, Mark wrote: > > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > On 24.04.2013 02:19, Chris wrote: > > > I'm generating a report with the following query: > > > > > > SELECT owner as id, > > > (SELECT count(*) FROM ticket b WHERE b.owner=a.owner AND > > status = 'new') > > > as New, > > > (SELECT count(*) FROM ticket b WHERE b.owner=a.owner AND status = > > > 'assigned') as Assigned, > > > (SELECT count(*) FROM ticket b WHERE b.owner=a.owner AND status = > > > 'fixed') as Fixed, > > > (SELECT count(*) FROM ticket b WHERE b.owner=a.owner AND status = > > > 'verified') as Verified, > > > (SELECT count(*) FROM ticket b WHERE b.owner=a.owner AND status = > > > 'closed') as Closed, > > > (SELECT count(*) FROM ticket b WHERE b.owner=a.owner AND status = > > > 'hold') as Hold > > > FROM ticket a > > > WHERE status <> '' > > > GROUP BY owner > > > > > > Which gives me something like: > > > > > > Id | New | Assigned | Fixed | Verified | Closed | Hold > > > --------------------------------------------------------------- > > > #user1 | 8 | 0 | 14 | 2 | 2 | 12 > > > #user2 | 2 | 10 | 1 | 0 | 5 | 2 > > > #user3 | 18 | 5 | 4 | 0 | 8 | 5 > > > #user4 | 1 | 1 | 0 | 1 | 1 | 0 > > > > > > Is there a way to get the "#user1" to lose the "#" symbol and link > > > somewhere useful? > > > -----Original Message----- > > From: [email protected] <javascript:> > > [mailto:[email protected] <javascript:>] On Behalf Of Steffen > Hoffmann > > Sent: 28 April 2013 23:01 > > To: [email protected] <javascript:> > > Subject: Re: [Trac] Non-ticket reports with the # sign prepended > > > > While I've to guess, I'm still pretty sure, that the 'owner > > as id' makes > > your owners become formatted like ticket numbers. If you just drop the > > 'as id' the extra '#' should vanish. > > > > On the second request there's not much to be done. There could be a > > sensible query showing user's ticket, but TracReports have not magic > > that I know of to create such links in the query output. It might be > > done by a simple Trac plugin, that mangles and rewrites the template > > after it got rendered (see post_process_request of > > IRequestFilter [1]). > > > > Steffen Hoffmann > > > > > > [1] > > > http://trac.edgewall.org/wiki/TracDev/PluginDevelopment/ExtensionPoints/trac.web.api.IRequestFilter > > > One way you could do this is to run your own macro that you can then plonk > on a wiki page. Take a look at the UserStats macro at trac-hacks.org [1] > which does something similar and I think could be easily adapted. > > ~ mark c > > [1] http://trac-hacks.org/wiki/UserStatsMacro > -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/trac-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
