Jen Maybe the problem with your SQL is that you have used as a column name (c.value AS "Workflow State") and as a text string (AND c.name = "Workflow State").
Maybe it will work if you change the column name to something slightly different. But I am no SQL expert. Cheers Steve McCusker Jen wrote: --------------------------------------------------- SELECT p.value AS __color__, c.value AS "Workflow State", id AS ticket, summary, component, version, milestone, priority, t.type AS type, (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 LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = "Workflow State") WHERE status IN ('new', 'assigned', 'reopened') AND p.name = t.priority AND p.type = 'priority' ORDER BY p.value, milestone, t.type, time ------------------------------------------------------ No virus found in this outgoing message. Checked by AVG. Version: 7.5.476 / Virus Database: 269.10.16/914 - Release Date: 23/07/2007 19:45 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---