On 9/7/06, Rainer Sokoll <[EMAIL PROTECTED]> 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
[EMAIL PROTECTED]
[EMAIL PROTECTED]
lecaros at irc.freenode.net
#edubuntu #edubuntu-es
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/trac-users
-~----------~----~----~----~------~----~------~--~---
