Thanks for your very fast response. This script doesnt work for me. It shows up all tickets.
I only need something like this, with ticketquery (this example works with a report): SELECT p.value AS __color__, id AS ticket, summary, owner, c.value AS value FROM ticket t, enum p, ticket_custom c WHERE t.id = c.ticket AND c.name = 'value' AND c.value LIKE 'testvalue2' AND p.name = t.priority AND p.type = 'priority' ORDER BY p.value Am Donnerstag, 2. Januar 2014 18:23:32 UTC+1 schrieb RjOllos: > > On Thursday, January 2, 2014 5:06:03 AM UTC-8, > [email protected] wrote: >> >> 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... >> > > I may not be understanding, but it appears that it should be as simple as: > > [[TicketQuery(custom-field-name=Testvalue2, format=table)]] > -- 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.
