- my $sql="SELECT Tickets.*, Queues.name, ".
- "position(Tickets.status in 'newopenstalledresolvedrejecteddeleted')".
- " AS svalue " .
- ( length($priority) ? ", objectcustomfieldvalues.content" : '' ).
- " $from_sql ".
- " ORDER BY svalue, ".
- " priority ". ( $priority_reverse ? 'ASC' : 'DESC' ). ", ".
- " id DESC ".
- " LIMIT $limit";
+ my $sql = "
+ SELECT Tickets.*,
+ Queues.Name AS Queue,
+ Users.Name AS Owner,
+ position(Tickets.Status in 'newopenstalledresolvedrejecteddeleted')
+ AS svalue
+ ". ( length($priority) ? ", ObjectCustomFieldValues.Content" : '' )."
+ $from_sql
+ ORDER BY svalue,
+ Priority ". ( $priority_reverse ? 'ASC' : 'DESC' ). ",
+ id DESC
+ LIMIT $limit
+ ";