Changes between Version 2 and Version 3 of TracReports

Timestamp:

Jun 8, 2011, 7:42:05 PM (13 years ago)

Author:

trac

Comment:

--

TracReports

@@ -17 +17 @@
   ''This will make the query module the default handler for the “View Tickets” navigation item. We encourage you to try this configuration and report back what kind of features of reports you are missing, if any.''
 
-  '''''You will almost definitely need to restart your httpd at this point.'''''
 
 A report consists of these basic parts:
@@ -43 +42 @@
 }}}
 Keep in mind that the integrity has to be maintained (i.e., ID has to be unique, and you don't want to exceed the max, since that's managed by SQLite someplace).
+
+You may also need to update or remove the report number stored in the report or query.
 
 == Navigating Tickets ==
@@ -104 +105 @@
 {{{
 SELECT id AS ticket, status, severity, priority, owner, 
-       time as created, summary FROM ticket 
+       time AS created, summary FROM ticket 
   WHERE status IN ('new', 'assigned', 'reopened')
   ORDER BY priority, time
@@ -166 +167 @@
 === Automatically formatted columns ===
  * '''ticket''' -- Ticket ID number. Becomes a hyperlink to that ticket. 
+ * '''id''' -- same as '''ticket''' above when '''realm''' is not set
+ * '''realm''' -- together with '''id''', can be used to create links to other resources than tickets (e.g. a realm of ''wiki'' and an ''id'' to a page name will create a link to that wiki page)
  * '''created, modified, date, time''' -- Format cell as a date and/or time.
-
  * '''description''' -- Ticket description field, parsed through the wiki engine.
 
 '''Example:'''
 {{{
-SELECT id as ticket, created, status, summary FROM ticket 
-}}}
+SELECT id AS ticket, created, status, summary FROM ticket 
+}}}
+
+Those columns can also be defined but marked as hidden, see [#column-syntax below].
 
 === Custom formatting columns ===
@@ -208 +212 @@
 numeric representation from the ''enum'' table.
 
-=== Changing layout of report rows ===
+=== Changing layout of report rows === #column-syntax
 By default, all columns on each row are display on a single row in the HTML
 report, possibly formatted according to the descriptions above. However, it's
@@ -218 +222 @@
 
  * '''`_column`'''  --  ''Hide data''. Prepending an underscore ('_') to a column name instructs Trac to hide the contents from the HTML output. This is useful for information to be visible only if downloaded in other formats (like CSV or RSS/XML).
+   This can be used to hide any kind of column, even important ones required for identifying the resource, e.g. `id as _id` will hide the '''Id''' column but the link to the ticket will be present.
 
 '''Example:''' ''List active tickets, grouped by milestone, colored by priority, with  description and multi-line layout''