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'],
+ staff_member => [ 'lower(staff_member.name)', 'date','start_time'],
+ order => [ 'order.ordnumber', 'date','start_time'],
+ part => [ 'lower(part.partnumber)', 'date','start_time'],
+ project => [ 'lower(project.projectnumber)', 'date','start_time'],
}
);
}