Hello,
I try to setup a new report to handle a field I added with
[ticket-custom] in trac.ini.
Here is [ticket-custom]:
[ticket-custom]
temps = text
temps.label = estimation
realise = text
realise.label = realise
and here is my report:
SELECT t.id AS ticket, summary, component, version, milestone, t.type AS
type, severity,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
time AS created,
changetime AS _changetime, description AS _description,
reporter AS _reporter,
c.value AS estimation,
p.value AS __color__
FROM ticket AS t, ticket_custom AS c, enum AS p
WHERE
t.id = c.ticket
AND c.name = 'temps'
AND p.name = t.priority
AND p.type = 'priority'
AND status IN ('new', 'assigned', 'reopened')
ORDER BY milestone, severity, time
As you can see, I would like to display the column estimation in the
report. The report is working but only the tickets with the field
estimation set are shown. I would like all the tickets: the ones with
estimation set and the others.
How can I do this ?
Regards.
--
Didier BRETIN
http://www.bretin.net/
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
