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 -~----------~----~----~----~------~----~------~--~---