New columns on report

[Paresh.Solanki@…]

Would it be possible to have a 'days open' type column available for reporting?

In analysing the issues reported (particularly from our legacy system) it would be useful to be able to determine how long an issue has been open before deciding what to do with it.

[Christian Boos]

For SQL reports, it's already possible, have a look at our report:20 (see #4296 for the corresponding SQL - it's PostgreSQL specific though).

For custom queries, this corresponds to #4966.

[anonymous]

It's not quite the same thing. You're showing when a ticket was last modified, but I need a report that shows when it was opened.

eg If there is an intermittent issue it may be 6 months old, but because there is a lot of activity on the issue, the last change may be a couple of weeks ago. In this instance, days open would be around 150, whereas last mod will be about 14.

[Christian Boos]

Replying to anonymous:

It's not quite the same thing. You're showing when a ticket was last modified, but I need a report that shows when it was opened.

Sure, it's not exactly the same, but those 2 informations always go together in the code, so #4966 and this one will get implemented together anyway. But let's keep this ticket open.

As for the report in #4296, it should be straightforward to modify it so that it uses the time column instead of the changetime one.

[Christian Boos]

r6566 makes it possible to select the Created column for achieving this.

(That ticket really bordering on duplicate, as I said previously …)