id summary reporter owner description type status priority component severity resolution keywords cc release 3018 Query strings having Syntax Problems C. M. "I've received a couple of different errors that seem to manifest from the SQL string. Both SQL strings appear to be incorrectly structured with values outside of parens and quotes not closing. {{{ SELECT t.id AS id,t.summary AS summary,t.priority AS priority,t.time AS time,t.changetime AS changetime,t.status AS status,t.owner AS owner,t.type AS type,priority.value AS priority_value,action_item.value AS action_item FROM ticket AS t LEFT OUTER JOIN ticket_custom AS action_item ON (id=action_item.ticket AND action_item.name='action_item') LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority) WHERE COALESCE(t.status,'') IN (u'accepted',u'assigned',u'new',u'reopened') AND COALESCE(t.owner,'')=u'username' AND COALESCE(t.type,'')=u'task' }}} ------ {{{ SELECT t.id AS id,t.summary AS summary,t.priority AS priority,t.time AS time,t.changetime AS changetime,t.'status AS 'status,priority.value AS priority_value,action_item.value AS action_item FROM ticket AS t LEFT OUTER JOIN ticket_custom AS action_item ON (id=action_item.ticket AND action_item.name='action_item') LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)WHERE COALESCE(t.'status,'')!=u""closed'"" }}}" defect new normal TaskListPlugin normal 0.11