Hello, i have set up following custom query to get the sum of cost from the custom_field 'tcf_cost_ap' in table ticket_custom. I'm able to set up a WHERE clause on the Table ticket, but how can i do that WHERE clause on other custom fields?
I would like to have the same query, but only if the custom field "signed" in the table ticket_custom = True. SELECT sum(c.value) as "Kosten" FROM ticket t, ticket_custom c WHERE t.id = c.ticket AND t.type = 'Bestellung' AND c.name = 'tcf_cost_ap' Can anone help me add this criteria? Thanks in Advance Dominik -- 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 post to this group, send email to trac-users@googlegroups.com. Visit this group at http://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
