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 ==