X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/11d2ae5772060a0426dc8722dfe69bf2c6aeceea..371ab59da0ebb21a8438cab732530e1cf5f9471c:/SL/DB/Helper/LinkedRecords.pm diff --git a/SL/DB/Helper/LinkedRecords.pm b/SL/DB/Helper/LinkedRecords.pm index bf91e6a7b..8b719aa9f 100644 --- a/SL/DB/Helper/LinkedRecords.pm +++ b/SL/DB/Helper/LinkedRecords.pm @@ -210,7 +210,7 @@ sub _linked_records_implementation { } # don't use rose retrieval here. too slow. - # instead use recursive sql to get all the linked record_links entrys, and retrieve the objects from there + # instead use recursive sql to get all the linked record_links entries and retrieve the objects from there my $query = <<""; WITH RECURSIVE record_links_rec_${wanted}(id, from_table, from_id, to_table, to_id, depth, path, cycle) AS ( SELECT id, from_table, from_id, to_table, to_id, @@ -313,6 +313,7 @@ sub sort_linked_records { 'SL::DB::RequirementSpec' => sub { $_[0]->id }, 'SL::DB::Letter' => sub { $_[0]->letternumber }, 'SL::DB::ShopOrder' => sub { $_[0]->shop_ordernumber }, + 'SL::DB::EmailJournal' => sub { $_[0]->id }, UNKNOWN => '9999999999999999', ); my $number_xtor = sub { @@ -343,6 +344,7 @@ sub sort_linked_records { 'SL::DB::PurchaseInvoice' => 150, 'SL::DB::Letter' => 200, 'SL::DB::ShopOrder' => 250, + 'SL::DB::EmailJournal' => 300, UNKNOWN => 999, ); my $score_xtor = sub {