X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/8915e7750d73593e86979e9a6a9016016a70c808..22f2c3e86aeea63b9e25b6ba249ca9062ae337f8:/SL/DB/Manager/TimeRecording.pm diff --git a/SL/DB/Manager/TimeRecording.pm b/SL/DB/Manager/TimeRecording.pm index e1e9b84e1..6992aa10d 100644 --- a/SL/DB/Manager/TimeRecording.pm +++ b/SL/DB/Manager/TimeRecording.pm @@ -16,8 +16,15 @@ __PACKAGE__->make_manager_methods; sub _sort_spec { return ( default => [ 'start_time', 1 ], - columns => { SIMPLE => 'ALL' , - customer => [ 'lower(customer.name)', ], + nulls => { + date => 'FIRST', + start_time => 'FIRST', + end_time => 'FIRST', + }, + columns => { SIMPLE => 'ALL' , + start_time => [ 'date', 'start_time' ], + end_time => [ 'date', 'end_time' ], + customer => [ 'lower(customer.name)', 'date','start_time'], } ); }