Hello RjOllos and thanks for your reply. My Problem is, that i need to combine two querys.
Example: Table Tickets: ---------------------------------- | Ticketnr. | Ticket | ---------------------------------- | 1 | Testticket | ---------------------------------- | 2 | Testticket2 | --------------------------------- | 3 | Testticket3 | --------------------------------- Table ticket_custom: -------------------------------- | Ticketnr. | Value | -------------------------------- | 1 | Testvalue1 | -------------------------------- | 2 | Testvalue2 | -------------------------------- | 3 | Testvalue2 | -------------------------------- Now i need a query, that shows me all Tickets with "Testvalue2". It is very simple with SQL, but i would like to have a tracquery for the tracwiki... Thanks, Florian Am Sonntag, 29. Dezember 2013 09:11:56 UTC+1 schrieb RjOllos: > > On Monday, December 16, 2013 6:29:59 AM UTC-8, > [email protected] wrote: >> >> Hello Folks, >> i need to know, how i can count results from table "ticket_custom". >> >> I created a specific field in "ticket_custom", works so far. When i >> create a ticket, i have an additional Dropdown Box. >> Now i would like to create a query to count tickets that have a specific >> value in this additonal field and use it vor the Trac-Wiki. >> >> Is this possbile? >> > > The TicketQuery macro has a "count" parameter. See docs for additional > details: > http://trac.edgewall.org/wiki/TracQuery#UsingtheTicketQueryMacro > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/groups/opt_out.
