IF( etype='ticketstate'
AND name='assigned' , 10, 0) +
IF( etype='ticketstate' AND
- name !='closed' AND name != 'new' , 100, 0) +
+ name !='closed' AND name != 'new'
+ AND
+ name !='CLOSED' AND name != 'NEW', 100, 0) +
IF( etype='ticketstate' , 0 , 1000) +
seqid
( CONCAT(etype , '.', name) != 'ticketstate.closed')
AND
( CONCAT(etype , '.', name) != 'ticketstate.reopened')
+ AND
+ ( CONCAT(etype , '.', name) != 'ticketstate.CLOSED')
");
break;