Changes between Version 1 and Version 2 of TracReports


Ignore:
Timestamp:
10/22/08 03:31:28 (10 years ago)
Author:
trac
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • TracReports

    v1 v2  
    3030 
    3131If a column header is a hyperlink (red), click the column you would like to sort by. Clicking the same header again reverses the order. 
     32 
     33== Changing Report Numbering == 
     34There may be instances where you need to change the ID of the report, perhaps to organize the reports better. At present this requires changes to the trac database. The ''report'' table has the following schema (as of 0.10): 
     35 * id integer PRIMARY KEY 
     36 * author text 
     37 * title text 
     38 * query text 
     39 * description text 
     40Changing the ID changes the shown order and number in the ''Available Reports'' list and the report's perma-link. This is done by running something like: 
     41{{{ 
     42update report set id=5 where id=3; 
     43}}} 
     44Keep 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). 
    3245 
    3346== Navigating Tickets ==