Hi,
I have the following custom report below. I'm trying to color code it
by owner and priority, is it possible to assign those columns with
different background colors? If not, I'm a bit confused about nested
case statements (I realize my ELSE handling below is incorrect, but I
can't find a syntax it likes), is it possible to assign a background
color to a user and then a text color based on priority?
SELECT priority AS __color__,
component AS __group__,
(CASE owner
WHEN 'user1' THEN 'background: #aee;'
WHEN 'user2' THEN 'background: #eae;'
WHEN 'user3' THEN 'background: #eea;'
WHEN 'user4' THEN 'background: #aae;'
WHEN 'user5' THEN 'background: #aea;'
WHEN 'user6' THEN 'background: #eaa;'
WHEN 'user7' THEN 'background: #aaa;'
ELSE
(CASE priority
WHEN 'p1' THEN 'color: #f00;'
WHEN 'p2' THEN 'color: #f00;'
WHEN 'p3' THEN 'color: #f00;'
WHEN 'p4' THEN 'color: #f00;'
WHEN 'p5' THEN 'color: #f00;'
END)
END) AS __style__,
id AS ticket, summary, component,owner, priority, time AS created,
changetime AS _changetime, description AS _description,
reporter AS _reporter
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE status IN ('new', 'assigned', 'reopened')
ORDER BY component, owner, priority, time
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to trac-users@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
