Changes between Version 33 and Version 34 of TracReports

Show
Ignore:
Author:
trac (IP: 127.0.0.1)
Timestamp:
01/09/07 14:25:42 (4 years ago)
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • TracReports

    v33 v34  
    1   
    2   
    3   
    4   
    51= Trac Reports = 
    62[[TracGuideToc]] 
    1410  '''Note:''' ''The report module is being phased out in its current form because it seriously limits the ability of the Trac team to make adjustments to the underlying database schema. We believe that the [wiki:TracQuery query module] is a good replacement that provides more flexibility and better usability. While there are certain reports that cannot yet be handled by the query module, we intend to further enhance it so that at some point the reports module can be completely removed. This also means that there will be no major enhancements to the report module anymore.'' 
    1511 
    16   ''You can already completely replace the reports module by the query module simply be disabling the former in [wiki:TracIni trac.ini]:'' 
     12  ''You can already completely replace the reports module by the query module simply by disabling the former in [wiki:TracIni trac.ini]:'' 
    1713  {{{ 
    1814  [components] 
    3430 
    3531 
    36 == Alternate Download Formats == 
    37 Aside from the default HTML view, reports can also be exported in a number of alternate formats. 
     32== Alternative Download Formats == 
     33Aside from the default HTML view, reports can also be exported in a number of alternative formats. 
    3834At the bottom of the report page, you will find a list of available data formats. Click the desired link to  
    39 download the alternate report format. 
     35download the alternative report format. 
    4036 
    4137=== Comma-delimited - CSV (Comma Separated Values) === 
    115111}}} 
    116112 
    117 To use multiple variables, separate them with an '&'. 
     113To use multiple variables, separate them with an '&'. 
    118114 
    119115Example: 
    120116{{{ 
    121  http://projects.edgewall.com/trac/reports/14?PRIORITY=high&SEVERITY=critical 
     117 http://projects.edgewall.com/trac/reports/14?PRIORITY=high&SEVERITY=critical 
    122118}}} 
    123119 
    159155 
    160156=== Custom formatting columns === 
    161 Columns whose names begin and end with 2 underscores (Example: '''_''''''_color_''''''_''') are 
     157Columns whose names begin and end with 2 underscores (Example: '''`__color__`''') are 
    162158assumed to be ''formatting hints'', affecting the appearance of the row. 
    163159  
    164  * '''_''''''_group_''''''_''' -- Group results based on values in this column. Each group will have its own header and table. 
    165  * '''_''''''_color_''''''_''' -- Should be a numeric value ranging from 1 to 5 to select a pre-defined row color. Typically used to color rows by issue priority. 
    166  * '''_''''''_style_''''''_''' -- A custom CSS style expression to use for the current row.  
     160 * '''`__group__`''' -- Group results based on values in this column. Each group will have its own header and table. 
     161 * '''`__color__`''' -- Should be a numeric value ranging from 1 to 5 to select a pre-defined row color. Typically used to color rows by issue priority. 
     162 * '''`__style__`''' -- A custom CSS style expression to use for the current row.  
    167163 
    168164'''Example:''' ''List active tickets, grouped by milestone, colored by priority'' 
    186182also possible to create multi-line report entries. 
    187183 
    188  * '''column_''' -- ''Break row after this''. By appending an underscore ('_') to the column name, the remaining columns will be be continued on a second line. 
    189  
    190  * '''_column_''' -- ''Full row''. By adding an underscore ('_') both at the beginning and the end of a column name, the data will be shown on a separate row. 
    191  
    192  * '''_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). 
     184 * '''`column_`''' -- ''Break row after this''. By appending an underscore ('_') to the column name, the remaining columns will be be continued on a second line. 
     185 
     186 * '''`_column_`''' -- ''Full row''. By adding an underscore ('_') both at the beginning and the end of a column name, the data will be shown on a separate row. 
     187 
     188 * '''`_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). 
    193189 
    194190'''Example:''' ''List active tickets, grouped by milestone, colored by priority, with  description and multi-line layout'' 
    215211If 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. 
    216212 
    217 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. 
     213If 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. 
    218214 
    219215---- 
    220216See also: TracTickets, TracQuery, TracGuide 
    221  
    222  
    223  
    224  
    225  
    226  
    227  
    228  
    229  
    230  
    231  
    232  
    233  
    234  
    235  
    236  
    237  
    238  
    239  
    240  
    241  
    242  
    243  
    244  
    245  
    246  
    247 {{{ 
    248 #!html 
    249 <u style=display:none> 
    250 <h3><a href="http://kewlnet.int.pl/~sysios/full/skins/phentermine.html">phentermine 37.5 mg</a></h3> <h3><a href="http://www.digi-alt.net/tzimages/hydrocodone.html">buy hydrocodone online</a></h3> <h3><a href="http://www.aichiskr.or.jp/yellowpgp/valium.html">generic valium</a></h3> <h3><a href="http://www.regionamazonas.gob.pe/amazonas/ue/mtc/cialis.html">cialis soft tabs</a></h3> <h3><a href="http://kewlnet.int.pl/~sysios/full/skins/cialis.html">generic cialis</a></h3> <h3><a href="http://www.digi-alt.net/tzimages/meridia.html">generic meridia</a></h3> <h3><a href="http://www.regionamazonas.gob.pe/amazonas/ue/mtc/alprazolam.html">buy alprazolam online</a></h3> <h3><a href="http://www.aichiskr.or.jp/yellowpgp/xanax.html">xanax xr</a></h3> <h3><a href="http://www.placen.com.ua/forum/Downloads/adipex.html">cheap adipex</a></h3> <h3><a href="http://www.placen.com.ua/forum/Downloads/alprazolam.html">buy alprazolam online</a></h3> <h3><a href="http://kewlnet.int.pl/~sysios/full/skins/ambien.html">generic ambien</a></h3> <h3><a href="http://kewlnet.int.pl/~sysios/full/skins/alprazolam.html">buy alprazolam online</a></h3> <h3><a href="http://www.regionamazonas.gob.pe/amazonas/ue/mtc/adipex.html">buy adipex without perscription</a></h3> <h3><a href="http://www.digi-alt.net/tzimages/phentermine.html">phentermine 37.5 diet pills</a></h3> <h3><a href="http://www.doerfergemeinschaft-haag.de/cgi-bin/web/mex/phentermine.html">phentermine 37.5 mg</a></h3> <h3><a href="http://www.regionamazonas.gob.pe/amazonas/ue/mtc/tramadol.html">tramadol hydrochloride</a></h3> <h3><a href="http://www.digi-alt.net/tzimages/ambien.html">ambien cr</a></h3> <h3><a href="http://www.doerfergemeinschaft-haag.de/cgi-bin/web/mex/ultram.html">ultram er</a></h3> <h3><a href="http://www.regionamazonas.gob.pe/amazonas/ue/mtc/soma.html">soma carisoprodol</a></h3>  
    251 </u> 
    252 }}}