Cannot view my closed tickets by closing date

[Raz Goren]

 

Hi

 

I want to be able to view open tickets by their closing date .

Is it possible todo it ?

 

Regards

Raz

[Matt Good]

Raz Goren wrote:
> I want to be able to view open tickets by their closing date .
>
> Is it possible todo it ?

If they're open, what do you consider the closing date?

-- Matt Good

[Raz Goren]

Sorry , my mistake , the tickets status is now closed .
I want to see the closing date .
Currently I can see only the opening date .
Also with open tickets I cannot filter them by opening date and of
course not by closing date .

Raz

[Christian Boos]

Raz Goren wrote:
> ...Also with open tickets I cannot filter them by opening date ...
>

Workaround: sort by id, as the tickets id sequence is chronological...

-- Christian

[Raz Goren]

That's OK for sorting , but the issue is that our developers want to see
for example what bugs they have closed this week so they can report it
in their weekly report .

Raz

-----Original Message-----
From: trac-...@googlegroups.com [mailto:trac-...@googlegroups.com]
On Behalf Of Christian Boos
Sent: Thursday, September 07, 2006 12:38 PM
To: trac-...@googlegroups.com
Subject: [Trac] Re: Cannot view my closed tickets by closing date

[Rainer Sokoll]

On Thu, Sep 07, 2006 at 07:16:28AM -0400, Raz Goren wrote:

> That's OK for sorting , but the issue is that our developers want to see
> for example what bugs they have closed this week so they can report it

You may try in your trac.ini

[components]
trac.ticket.report.* = disabled

cf. http://trac.edgewall.org/wiki/TracReports

Rainer

[José Lecaros]

On 9/7/06, Rainer Sokoll <R.So...@intershop.de> wrote:
>
> On Thu, Sep 07, 2006 at 07:16:28AM -0400, Raz Goren wrote:
>
> > That's OK for sorting , but the issue is that our developers want to see
> > for example what bugs they have closed this week so they can report it
>

you can try with this query report

SELECT p.value AS __color__,
id AS ticket, summary as Summary, component as component, version,
milestone, t.type AS tipo,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS Owner,
time AS created,
changetime AS Changetime, description AS _description,
reporter AS _reporter
FROM ticket t, enum p
WHERE status IN ('closed')
AND p.name = t.priority AND p.type = 'priority'
ORDER BY p.value, milestone, t.type, time

sl3

--
José Lecaros Cisterna
móvil: (56+9)789 78 00
lec...@ubuntu-cl.org
jose.l...@gmail.com

lecaros at irc.freenode.net
#edubuntu #edubuntu-es