Hi,
On Wed, Apr 24, 2013 at 9:19 AM, Chris <[email protected]> wrote:
> Is there a way to get the "#user1" to lose the "#" symbol and link somewhere
> useful?
Try the following. The "description" column is rendered as Trac Wiki.
Works well on Trac 0.12.5.
-------
SELECT
'{{{#!Span
[query:owner=' || owner || '&group=status ' ||
(CASE WHEN owner = '' THEN '(none)' ELSE owner END) ||']
}}}' AS description,
(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
-------
--
Jun Omae <[email protected]> (大前 潤)
--
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.
