X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FDB%2FManager%2FOrderItem.pm;h=379e1fdb7f98de617323be8d55245480406abef0;hb=53593baa211863fbf66540cf1bcc36c8fb37257f;hp=e964f4ff3f85a11f437a34f49fe8df1eeba051c6;hpb=a6a6121c8a7b419bd4130c9374051dba76e4aac6;p=kivitendo-erp.git 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;