Report from Tickets change history

[Aidin Gharibnavaz]

Hi All!

I wonder if there's a way to generate a report from Tickets' change history.

For example, how many time this ticket reopened?
Or, Which tickets are done after a specific date?

Is it possible?

Thank in advance.

[Aidin Gharibnavaz]

No reply means there's no way? :`(
So I have to start writing a custom plug-in.

[Leo]

Hi Aidin

I think that you won't need write a new plugin. A simple sql query can resolve your problem.

What you need exactly, a description of the changes or numbers about your tickets.

[osimons]

On Aug 30, 1:13 pm, Aidin Gharibnavaz <ai...@aidinhut.com> wrote:
> No reply means there's no way? :`(
> So I have to start writing a custom plug-in.
>
> ---------- Forwarded message ----------
>

> I wonder if there's a way to generate a report from Tickets' change history.
>
> For example, how many time this ticket reopened?
> Or, Which tickets are done after a specific date?
>
> Is it possible?

Using SQL reports you can write whatever SQL you want across any
table. Here are some custom reports that that may inspire you:

http://trac.edgewall.org/wiki/CookBook/Configuration/Reports


:::simon

[Aidin Gharibnavaz]

Thank you both for your answers.

I didn't know about SQL reports.

I will give it a try as soon as I gain some free time.

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.

To view this discussion on the web visit https://groups.google.com/d/msg/trac-users/-/FRGRrKR08BQJ.

To post to this group, send email to trac-...@googlegroups.com.
To unsubscribe from this group, send email to trac-users+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.