Hi everybody,
we're using Trac tickets to organize work and I was asked to add an
"effort" field to track costs. (Actual hours spent are tracked elsewhere
and it's a mess but it's ">0", so anyways...
The field is called "effort" and using the following query I can add a
"total row" at the end to sum up the effort values:
SELECT
id AS ticket, summary, c.value AS effort
FROM
ticket t, ticket_custom c
WHERE
status IN ('new') AND t.id = c.ticket AND c.name = 'effort' AND
t.summary like '$SUMMARY%'
UNION
SELECT
'Total', ' ', sum(c.value)
FROM
ticket t, ticket_custom c
WHERE
status IN ('new') AND t.id = c.ticket AND c.name = 'effort' AND
t.summary like '$SUMMARY%'
Unfortunately the report interprets the "Total" column as ticket id like
this:
[image: snap.png]
Obviously "#Total" is not a valid ticket link! :-)
Anybody an idea on how to fix it?
kind regards,
Florian
--
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 trac-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/trac-users/ebecc87c-825a-405f-b4ba-6672fbfdcc55%40googlegroups.com.
