Hello Roger
I am not sure if you question is about the report number or the report
query.
Generally you can simply edit i.e. update an existing report using the
"edit" field of the report in the TRAC web interface. This will not
change the report number. Not even if you change the report style from
SQL query to "TracQuery" expression.
In the GUI you cannot change the report number for existing reports. In
the GUI you only chance is to delete all reports and start from scratch
with number {1}.
Otherwise you would need to manipulate the database. I have done this.
The reports are in the "report" table of course and "id" is the report
number which one can manipulate.
Below is an example report which shows all open tickets. TracQuery
syntax is used for this report, instead of SQL.
query:?status=accepted & status=assigned & status=new & status=reopened
& max=1000 & col=id & col=summary & col=status & col=owner & col=type &
col=priority & col=milestone & col=component & col=version &
col=resolution & col=time & col=changetime & col=reporter & order=id
Clemens
Roger Oberholtzer wrote on 28.01.2025 at 10:55:
My Trac has some reports that I would like to update how they are
done. As an example, report 1 (Active tickets) is implemented as:
SELECT p.value AS __color__,
id AS ticket, summary, milestone, t.type AS type,
owner, status,
time AS created,
changetime AS _changetime, t.description AS _description,
reporter AS _reporter
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE status <> 'closed'
ORDER BY CAST(p.value AS int), milestone, t.type, time
I would like to change report 1 so Active Tickets are selected in the
newer way where you can select filters, columns, etc from the GUI.
I want to keep the report number the same. So how could I do this
change? I am guessing these are defined in the trac database. Is there
a how-to on doing this change? I surely do not want to muck up the
database!
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to trac-users+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/trac-users/45c22f9a-9843-4f3b-9b28-f057822f087b%40osypkamed.com.
