- my $sql = "SELECT tickets.*, queues.name".
- ( length($priority) ? ", objectcustomfieldvalues.content" : '' ).
- " $from_sql ORDER BY priority, id DESC LIMIT $limit";
+ my $sql="SELECT tickets.*, queues.name, ".
+ "position(tickets.status in 'newopenstalledresolvedrejecteddeleted')".
+ " AS svalue " .
+ ( length($priority) ? ", objectcustomfieldvalues.content" : '' ).
+ " $from_sql ORDER BY svalue, priority DESC, id DESC LIMIT $limit";
+ warn "$me $sql (@param)" if $DEBUG;