On 9/2/05, Adrian Holovaty <[EMAIL PROTECTED]> wrote:
>
> On 9/1/05, Jeremy Dunck <[EMAIL PROTECTED]> wrote:
> > Can we get a report which takes wildcards for ticket summary and
> > description?
> >
> > With a small number of active tickets, it's not such an issue, but
> > it's at 160 and climbing slowly.
>
> What do you mean?
Sorry, from here[1], I see that Trac admins can add reports to the
list of ones supplied with the software.
I also see that reports can be parameterized, so that a like clause
could be used on fields. This could be used find issues which include
the text "DB", for example.
I'm asking that a report be added which supports parameterization and
uses that parameter to find issues including that text in the summary
and description fields.
I think this query would do something like I want (not tested, since I
don't have an install of trac handy):
SELECT id AS ticket, status, severity, priority, owner,
time as created, summary FROM ticket
WHERE status IN ('new', 'assigned', 'reopened')
AND (summary like '$in_summary' or description like '$in_description')
ORDER BY priority, time
[1]
http://code.djangoproject.com/wiki/TracReports
