Re: [Trac] Clean up ticket views

Roger Oberholtzer wrote on 06.02.2026 at 11:39:
> I'm running trac 1.5.4.dev0. I should update...
> 
> My question is about ticket queries. I have a mix of the original
> format queries that came with trac long ago, as well as newer ones
> that use the more modern syntax.
> 
> I would like to clean this up. Is there a best way to do this that
> doesn't break something? I'm thinking in terms of the order you delete
> things. Or maybe it is best to edit the database to move queries
> around and remove some?

Hi Roger

As you probably know, reports i.e. queries have numbers. These number 
can be used inside Wiki text. For example report:1 or just {1} points to

https://trac.edgewall.org/report/3

You can add, edit or delete reports in the TRAC web GUI. But if you 
remove a report, then possible wiki references will be dead.

You cannot reorder or renumber reports via web GUI. New tickets always 
get a number as (maximum +1).

In the database the reports are in table "reports". It is easy to change 
the report number in the database; or add, remove, edit reports. I have 
done that.

I used to create a report with a high number e.g. {99} in the database. 
If my users create new reports via web GUI, then numbers will be {100}, 
{101} etc. This way, I can reserve all report numbers below {99} for my 
purposes.

Clemens

-- 
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+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
To view this discussion visit https://groups.google.com/d/msgid/trac-users/1014a97b-a84f-4e42-a571-837d1a35e26d%40osypkamed.com.