X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/a6a6121c8a7b419bd4130c9374051dba76e4aac6..53593baa211863fbf66540cf1bcc36c8fb37257f:/SL/DB/Manager/OrderItem.pm diff --git a/SL/DB/Manager/OrderItem.pm b/SL/DB/Manager/OrderItem.pm index e964f4ff3..379e1fdb7 100644 --- a/SL/DB/Manager/OrderItem.pm +++ b/SL/DB/Manager/OrderItem.pm @@ -34,11 +34,11 @@ sub _sort_spec { qty => [ 'qty' ], ordnumber => [ 'order.ordnumber' ], customer => [ 'lower(customer.name)', ], - position => [ 'trans_id', 'runningnumber' ], + position => [ 'trans_id', 'position' ], reqdate => [ 'COALESCE(orderitems.reqdate, order.reqdate)' ], orddate => [ 'order.orddate' ], - sellprice => [ 'sellprice' ], - discount => [ 'discount' ], + sellprice => [ 'orderitems.sellprice' ], + discount => [ 'orderitems.discount' ], transdate => [ 'orderitems.transdate::date', 'order.reqdate' ], }, default => [ 'position', 1 ], @@ -46,6 +46,6 @@ sub _sort_spec { ); } -sub default_objects_per_page { 40 } +sub default_objects_per_page { 15 } 1;