From f8a0cf101f15dcf6dbabceef03b4a8885db2b39f Mon Sep 17 00:00:00 2001
From: Jeff Davis <jdavis@sitka.bclibraries.ca>
Date: Thu, 9 Mar 2023 12:46:54 -0800
Subject: [PATCH] LP#2009891: add item author to
 open-ils.actor.carousel.get_contents

Signed-off-by: Jeff Davis <jdavis@sitka.bclibraries.ca>
---
 .../lib/OpenILS/Application/Actor/Carousel.pm         | 19 ++++++++-----------
 1 file changed, 8 insertions(+), 11 deletions(-)

diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Application/Actor/Carousel.pm b/Open-ILS/src/perlmods/lib/OpenILS/Application/Actor/Carousel.pm
index cc5d0ec13b..34ee4f269a 100644
--- a/Open-ILS/src/perlmods/lib/OpenILS/Application/Actor/Carousel.pm
+++ b/Open-ILS/src/perlmods/lib/OpenILS/Application/Actor/Carousel.pm
@@ -37,23 +37,20 @@ sub get_carousel_contents {
         name => $carousel->name
     };
     my $q = {
-        select => { bre => ['id'], mfde => [{ column => 'value', alias => 'title' }] },
+        select => { bre => ['id'], rmsr => ['title','author'] },
         from   => {
-            bre => {
-                cbrebi => {
-                    join => {
-                        cbreb => {
-                            join => { cc => {} }
-                        }
-                    }
+            cbrebi => {
+                cbreb => {
+                    join => { cc => {} }
                 },
-                mfde => {}
+                bre => {
+                    join => { rmsr => { fkey => 'id', field => 'id' } }
+                }
             }
         },
         where  => {
             '+cc' => { id => $id },
-            '+bre' => { deleted => 'f' },
-            '+mfde' => { name => 'title' }
+            '+bre' => { deleted => 'f' }
         },
         order_by => {cbrebi => ['pos','create_time']}
     };
-- 
2.11.0