On Monday, September 16, 2019 at 11:39:39 PM UTC-7, Florian Schricker wrote:
>
> 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
>
The other approach you could take would be to try the advanced formatting
features. Have you read through this section?:
https://trac.edgewall.org/wiki/TracReports#AdvancedReports:CustomFormatting
I don't know if it's possible to modify one row in the column to remove the
hyperlink formatting for just one row.
- Ryan
--
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/8a3055b4-6b6a-426d-8487-46726f30f2db%40googlegroups.com.
