Changes between Version 14 and Version 15 of TracReports

Timestamp:

Feb 10, 2005, 5:55:39 AM (19 years ago)

Author:

jim@…

Comment:

Added hints for custom field reporting

TracReports

@@ -192 +192 @@
 }}}
 
+=== Reporting on custom fields ===
+
+If you have added custom fields to your tickets (experimental feature in v0.8, see TracTicketsCustomFields), you can write a SQL query to cover them. You'll need to make a join on the ticket_custom table, but this isn't especially easy.
+
+If you have tickets in the database ''before'' you declare the extra fields in trac.ini, there will be no associated data in the ticket_custom table. To get around this, use SQL's "LEFT OUTER JOIN" clauses. See TracIniReportCustomFieldSample for some examples.
 
 ----