The following Query more or less gives me the output I desire:
SELECT id AS ticket, c1.value AS Requirement,
(CASE c2.value WHEN '1' THEN 'Yes' ELSE 'No' END) AS Complete,
(CASE c5.value WHEN '1' THEN 'Yes' ELSE 'No' END) AS CCB,
summary, component, changetime AS date, milestone AS Build,
(CASE c3.value WHEN '0' THEN 'None' ELSE c3.value END) AS Design,
(CASE c4.value WHEN '0' THEN 'None' ELSE c4.value END) AS Test
FROM ticket t, ticket_custom c1, ticket_custom c2, ticket_custom c3,
ticket_custom c4, ticket_custom c5
WHERE t.id = c1.ticket AND
c1.name = 'requirement' AND
t.id = c2.ticket AND
c2.name = 'rqmt_complete' AND
t.id = c3.ticket AND
c3.name = 'design' AND
t.id = c4.ticket AND
c4.name = 'test' AND
t.id = c5.ticket AND
c5.name = 'ccb_app'
The problem as I am sure you are aware is that tickets that do not
have these fields do not show up. I have tried a number of variations
of JOIN which shows the tickets with out entries but since there are a
number of custom fields, I get a lot of redundant entries.
Is there a way I can use a join but only get one row per ticket?
In addition the design and test fields are links back into SVN for the
documents. THese show up as text in the report. Is there a way I can
modify the CSS or something to have them show up as links back into
subversion sort of like source:/trunk/project/docs/test?
Thank you
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
