Changes between Version 4 and Version 5 of TracReports

Timestamp:

Mar 20, 2004, 9:39:27 PM (20 years ago)

Author:

daniel

Comment:

—

TracReports

@@ -66 +66 @@
 
 ----
+
+
+== Advanced Reports: Dynamic Variables ==
+For more flexible reports, Trac supports the use of ''dynamic variables'' in report SQL statements. 
+In short, dynamic variables are ''special'' strings that are replaced by custom data before query execution.
+
+=== Using Variables in a Query ===
+The syntax for dynamic variables is simple, any upper case word beginning with '$' is considered a variable.
+
+Example:
+{{{
+SELECT id AS ticket,summary FROM ticket WHERE priority='$PRIORITY'
+}}}
+
+To assign a value to $PRIORITY when viewing the report, you must define it as an argument in the report URL, leaving out the the leading '$'.
+
+Example:
+{{{
+ http://projects.edgewall.com/trac/reports/14?PRIORITY=high
+}}}
+
+
+=== Special/Constant Variables ===
+There is one ''magic'' dynamic variable to allow practical reports, its value automatically set without having to change the URL. 
+
+ * $USER -- Username of logged in user.
+
+Example (''List all tickets assigned to me''):
+{{{
+SELECT id AS ticket,summary FROM ticket WHERE owner='$USER'
+}}}
+
+
+----
+
 
 == Advanced Reports: Custom Formatting ==
@@ -141 +176 @@
 
 
-
-----
-
-== Sample Reports ==
-'''status and summary for all tickets'''
-
-{{{
-SELECT id as ticket, status, summary FROM ticket
-}}}
-
-----
-'''all active tickets, sorted by priority and time'''
-
-{{{
-SELECT id AS ticket, status, severity, priority, owner, 
-       time as created, summary FROM ticket 
-  WHERE status IN ('new', 'assigned', 'reopened')
-  ORDER BY priority, time
-}}}
-
-----
-'''active tickets, grouped by milestone and sorted by priority'''
-
-{{{
-SELECT id AS ticket, milestone, status, severity, 
-       priority, component, owner, summary 
-  FROM ticket 
-  WHERE status IN ('new', 'assigned', 'reopened')
-  ORDER BY milestone, 
-    (CASE priority 
-      WHEN 'highest' THEN 0 
-      WHEN 'high' THEN 1 
-      WHEN 'normal' THEN 2 
-      WHEN 'low' THEN 3 
-      ELSE 4 
-    END), severity, time
-}}}
-
-
 ----
 See also: TracTickets, TracGuide