I can't figure out why the following leaves unassigned tickets in a group with no title. Any help is appreciated. Thanks.
SELECT p.value AS __color__, (CASE WHEN owner ISNULL THEN ' * Unassigned * ' ELSE owner END) AS __group__, id AS ticket, summary, milestone, priority, date(milestone.Due,'unixepoch') as due, status, time AS created, changetime AS _changetime, t.description AS _description FROM ticket t, enum p JOIN milestone ON milestone.name=t.milestone WHERE status <> 'closed' AND p.name = t.priority AND p.type = 'priority' ORDER BY owner, milestone.Due, p.value, t.type, time -- Christopher Nelson ___________________________________________________ SIXNET - Innovative. Open. Industrial Data Products. PO Box 767, 331 Ushers Road, Clifton Park, NY 12065 Phone: +1(518)877-5173, Facsimile: +1(518)877-8346 E-mail: mailto:[EMAIL PROTECTED] Get product details at http://www.sixnetio.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
