+ push @values_user, $employee_id;
+ }
+
+ my $order_by = '';
+
+ if ($form->{sort} ne 'title') {
+ my %sort_columns = (
+ 'follow_up_date' => [ qw(fu.follow_up_date fu.id) ],
+ 'created_on' => [ qw(created_on fu.id) ],
+ 'subject' => [ qw(lower(n.subject)) ],
+ );
+
+ my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';
+ my $sortkey = $sort_columns{$form->{sort}} ? $form->{sort} : 'follow_up_date';
+ $order_by = 'ORDER BY ' . join(', ', map { "$_ $sortdir" } @{ $sort_columns{$sortkey} });