Changes between Version 7 and Version 8 of TracIniReportCustomFieldSample

Timestamp:

Mar 30, 2007, 12:57:45 PM (17 years ago)

Author:

anonymous

Comment:

—

TracIniReportCustomFieldSample

@@ -154 +154 @@
 
 }}}
+
+== Example 5 ==
+We wanted to query  all custom_ticket.value of a certain type (custom_ticket.name), where a different custom_ticket.value of the same ticket was met.
+
+'''trac.ini:'''
+{{{
+[ticket-custom]
+duration = text
+duratino.label = Duration
+
+customer = text
+customer.label = Customer
+}}}
+
+This obviously didn't work:
+
+'''Custom SQL:'''
+
+{{{
+SELECT 
+  ticket_custom.value as Duration,
+  FROM ticket_custom
+  WHERE ticket_custom.name = 'duration'
+  AND ticket_custom.value = 'Our Customer'
+}}}
+
+What we did was make a "loop" INNER JOIN ticket_custom on ticket_custom.ticket like this:
+
+'''Custom SQL:'''
+
+{{{
+SELECT 
+  tc1.value as Duration,
+  FROM ticket_custom tc1
+  INNER JOIN ticket_custom tc2
+  ON tc1.ticket = tc2.ticket
+  WHERE tc1.name = 'duration'
+  AND tc2.value = 'Our Customer'
+}}}