$sortby = "LOWER($sortby)"
if $sortby eq 'username';
push @extra_sql, "$sortby IS NOT NULL"
- if $sortby eq 'uid';
+ if $sortby eq 'uid' || $sortby eq 'seconds';
$orderby = "ORDER BY $sortby";
}
' LEFT JOIN cust_main USING ( custnum ) ';
#here is the agent virtualization
-push @extra_sql, $FS::CurrentUser::CurrentUser->agentnums_sql;
+push @extra_sql, $FS::CurrentUser::CurrentUser->agentnums_sql(
+ 'null_right' => 'View/link unlinked services'
+ );
my $extra_sql =
scalar(@extra_sql)