Changes between Version 57 and Version 58 of SimpleMultiProjectPlugin

Timestamp:

Sep 21, 2015, 6:10:57 PM (9 years ago)

Author:

anonymous

Comment:

Add Example SQL Statement to include the Project Name into the Ticket Reports - not optimized or anything else

SimpleMultiProjectPlugin

@@ -86 +86 @@
 [[Image(timeline_projects_filter.png, 400px)]]
 
+----
+You also can include the Project Name in your Ticket Queries by adding a join to "ticket_custom".
+Example:
+
+{{{#!sql
+SELECT p.value AS __color__,
+   id AS ticket, summary, 
+   tc.value AS 'Project-Name', # display the Project Name in the Ticket Overview
+   version, milestone, t.type AS type,
+   owner, status,
+   time AS created,
+   changetime AS _changetime, description AS _description,
+   reporter AS _reporter
+  FROM ticket t
+  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
+  LEFT JOIN ticket_custom tc ON t.id = tc.ticket AND tc.name = 'project' # add the join to ticket_custom and only select the Project-Name
+  WHERE status <> 'closed'
+  ORDER BY CAST(p.value AS integer), milestone, t.type, time
+}}}
+
 == Bugs/Feature Requests