Thanks!
that did the trick!
On Jul 2, 7:02 pm, Eli Carter <[EMAIL PROTECTED]> wrote:
> On Monday 02 July 2007, Martin H wrote:
>
>
>
> > SELECT distinct
> > component AS __group__,
> > id AS ticket,
> > summary,
> > type,
> > owner,
> > time
> > FROM ticket
> > WHERE status IN ('new', 'assigned', 'reopened')
>
> > Hello!
> > This report is giving me repeated groups for the same component. I'd
> > appreciate help on the issue!
>
> You need to ORDER BY component. Look at report 3 for an example.
>
> Eli
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
