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? Please forgive the ugly SQL, I'm pretty rusty. I'm open to suggestions on cleaning it up. -- 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.
