- my $queue_sql = " customfields.queue = ( select id from queues
- where queues.name = ? )
- or ( ? = '' and customfields.queue = 0 )";
+ my $queue_sql = " ObjectCustomFields.ObjectId = ( SELECT id FROM queues
+ WHERE queues.name = ? )
+ OR ( ? = '' AND ObjectCustomFields.ObjectId = 0 )";
+
+ my $customfield_sql =
+ "customfield = (
+ SELECT CustomFields.Id FROM CustomFields
+ JOIN ObjectCustomFields
+ ON ( CustomFields.id = ObjectCustomFields.CustomField )
+ WHERE LookupType = 'RT::Queue-RT::Ticket'
+ AND name = ?
+ AND ( $queue_sql )";
+
+ push @param, $priority_field,
+ $priority_field_queue,
+ $priority_field_queue;