Changes between Version 4 and Version 5 of DynamicVariablesPlugin


Ignore:
Timestamp:
Jan 2, 2011, 5:53:37 AM (4 years ago)
Author:
robguttman
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DynamicVariablesPlugin

    v4 v5  
    2929
    3030    You can alternatively use the Trac Web Admin GUI to enable any or all rules.
     31
     32 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:
     33{{{
     34SELECT p.value AS __color__,
     35   t.id AS ticket, summary, component, severity, reporter,
     36   t.time AS created,
     37   changetime AS _changetime, t.description AS _description
     38  FROM ticket t
     39  LEFT OUTER JOIN milestone m ON t.milestone=m.name
     40  LEFT JOIN enum p ON p.name = t.severity AND p.type = 'severity'
     41  LEFT OUTER JOIN ticket_custom q ON q.ticket = t.id and q.name = 'queue'
     42  WHERE t.status <> 'closed' AND q.value = '$QUEUE'
     43    AND milestone= '$MILESTONE'
     44  ORDER BY m.due ASC, p.value, severity, t.time
     45}}}
    3146
    3247== Bugs/Feature Requests ==