Changes between Version 4 and Version 5 of DynamicVariablesPlugin

Timestamp:

Jan 2, 2011, 4:53:37 AM (13 years ago)

Author:

Rob Guttman

Comment:

--

DynamicVariablesPlugin

@@ -29 +29 @@
 
     You can alternatively use the Trac Web Admin GUI to enable any or all rules.
+
+ 3. Create/modify reports so that the name used for dynamic variables exactly match the name of the select field that it corresponds to.  For example, a report for a specific {{{milestone}}} that also queries for a custom {{{queue}}} select field could be specified like this:
+{{{
+SELECT p.value AS __color__,
+   t.id AS ticket, summary, component, severity, reporter,
+   t.time AS created,
+   changetime AS _changetime, t.description AS _description
+  FROM ticket t
+  LEFT OUTER JOIN milestone m ON t.milestone=m.name
+  LEFT JOIN enum p ON p.name = t.severity AND p.type = 'severity'
+  LEFT OUTER JOIN ticket_custom q ON q.ticket = t.id and q.name = 'queue'
+  WHERE t.status <> 'closed' AND q.value = '$QUEUE'
+    AND milestone= '$MILESTONE'
+  ORDER BY m.due ASC, p.value, severity, t.time
+}}}
 
 == Bugs/Feature Requests ==