Changes between Initial Version and Version 3 of Ticket #3018


Ignore:
Timestamp:
Dec 16, 2010, 12:13:52 AM (13 years ago)
Author:
Ryan J Ollos
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #3018

    • Property Status changed from new to assigned

  • Ticket #3018 – Description

    initial v3  
    22and quotes not closing.
    33
    4 .........
     4{{{
    55SELECT 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
    66FROM ticket AS t LEFT OUTER JOIN ticket_custom AS action_item ON (id=action_item.ticket AND action_item.name='action_item')
    77LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)
    88WHERE COALESCE(t.status,'') IN (u'accepted',u'assigned',u'new',u'reopened') AND COALESCE(t.owner,'')=u'username' AND COALESCE(t.type,'')=u'task'
    9 
     9}}}
    1010------
     11{{{
    1112SELECT 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
    1213LEFT OUTER JOIN ticket_custom AS action_item ON (id=action_item.ticket AND action_item.name='action_item')
    1314LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)WHERE COALESCE(t.'status,'')!=u"closed'"
     15}}}