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 trac-users@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
