Hi,
quick heads-up as I was testing things with non-admin user: The query is
not working at all instead I receive:
ValueError: invalid literal for int() with base 10: 'Total'
Does anybody know why the query (cited below) works for admin user but not
for others?
regards,
Florian
Am Dienstag, 17. September 2019 08:39:39 UTC+2 schrieb Florian Schricker:
>
> 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%'
>
--
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/3c0ba03c-4e5d-441b-be7f-24492f23cdf7%40googlegroups.com.
