Edgewall Software

Opened 15 years ago

Closed 15 years ago

#8292 closed enhancement (worksforme)

Drill-Down Reports

Reported by: Denis de Bernardy <ddebernardy@…> Owned by:
Priority: normal Milestone:
Component: general Version: none
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


It would be sweet if, in addition to the automatically added sorts that appear in the custom header, trac added automatic filter links within the cells.

A simplified example to make sense of this. Consider this report:

  id AS ticket,
  summary as summary,
FROM ticket
WHERE status <> 'closed'

I wanted to change it into this:

  id AS ticket,
  summary as summary,
FROM ticket
WHERE status <> 'closed'
  THEN severity = $SEVERITY
  ELSE 1

Two problems:

  • trac returns an error when $SEVERITY is not present in the url
  • the fields need to be manually entered in the url for it to work


  • on report load, initialize variables named after each column, even if it is not present in the url (this would fix my undefined variable proble)
  • in the report itself, add a link to the same report, with that parameter in the url, when no other link would normally apply
  • turn the milestone link into a drill-down link

It would then become possible to have:


whose severity field, for instance, would link to urls like:


and things would be ordered/grouped in whichever way is defined by the report.

Bonus suggestion: create a shorthand syntax, e.g.:

  id AS ticket,
  summary as summary,
FROM ticket
WHERE status <> 'closed'

where $_SEVERITY would expand as described above. the link would then be only added with to the fields whose filters are deemed desired, while the remaining ones would be ignored.

Attachments (0)

Change History (6)

comment:1 by Remy Blank, 15 years ago

The issues you mention about missing variables have been solved in trunk in #7293. Basically, reports containing variable references now have a form at the top allowing to edit the argument values. Combined with your CASE trick, this already allows implementing drill-down reports, although not "single-click" ready.

Also, the parameter syntax in reports is already complicated as is, so I'm against adding yet another syntax for a shorthand.

I suggest "worksforme".

comment:2 by Denis de Bernardy <ddebernardy@…>, 15 years ago

super. trouble with closing this as worksforme is there is no means to add html in the form. it's not single-click ready.

the real issue is when you've plenty of tickets around. in my own trac, it's no big deal, as there are never more than two pages of tickets. over at wordpress.org, however, we had well over 1,000 a few weeks ago. the reports are much about useless.

I'd like it to be possible for moderators and committers to use this report:


In such a way that they can quickly scan through a component, a severity, a workflow state, whatever, in a single click.

Perhaps we could add something like this instead, in the select syntax?

select severity as severity*

comment:3 by Christian Boos, 15 years ago

Resolution: worksforme
Status: newclosed

I don't think we're ever going that for with TracReports. Those are intended to write very specific, specialized, reports that you can't easily get with the more generic TracQuery (custom queries). There, you can very easily add your own filters so you could quite easily scan through a component, a severity, a workflow state, whatever, in a few clicks ;-)

comment:4 by Denis, 15 years ago

Resolution: worksforme
Status: closedreopened

Open source software projects are just beyond me, on occasion. Why is it that they're so air-tight to usability improvements?

Trac custom queries are hopelessly useless as they are. Consider the report I highlight above, and wonder how I can extract the workflow state using a custom query. You cannot. Custom queries return results in a random order at best, you cannot filter custom queries using a complicated expression.

Drill down on reports would allow to custom-query these specialized reports you mentioned when they're too long, and that would give trac a tremendous boost in usefulness.

Plus, you're closing it as worksforme, but the fact of the matter is it doesn't: You cannot insert html in the report's description to make sub-reports easily available. If that was possible than I'd agree I'd be beating a dead horse and move on. But as things currently are, you cannot.

Merely adding the possibility to add a GET form in the report's description could work…

comment:5 by Christian Boos, 15 years ago

Well, the worksforme is in agreement with what Remy explained in comment:1. Have you tried his suggestions?

comment:6 by Denis, 15 years ago

Resolution: worksforme
Status: reopenedclosed

Aye, nevermind, and terribly sorry about the rant. I had completely missed that sentence.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.