From 5e33ee89e6d169e42a3f8b3d7ce7a5642a989ed2 Mon Sep 17 00:00:00 2001
From: Lari Taskula <lari.taskula@hypernova.fi>
Date: Tue, 29 Aug 2023 19:14:56 +0000
Subject: [PATCH] Bug 34639: Restore order_by

To test:
1. prove t/db_dependent/Koha/Item.t
2. Observe success

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Aleisha Amohia <aleishaamohia@hotmail.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit 066c0b3e0de7b2d49f673cea0eddf67b3b5eb171)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
---
 Koha/Schema/Result/Item.pm | 1 +
 1 file changed, 1 insertion(+)

diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm
index 99218918b3..accb2bbd3d 100644
--- a/Koha/Schema/Result/Item.pm
+++ b/Koha/Schema/Result/Item.pm
@@ -984,6 +984,7 @@ __PACKAGE__->has_many(
             "$args->{foreign_alias}.datecancelled" => undef,
         };
     },
+    { order_by => [ { -desc => 'datesent' }, { -asc => 'daterequested' } ] }
 );
 
 # Relationship with bundled items
-- 
2.39.2