From e727f26b45ff017d0e0af7be5778e3e77cdec54d Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
Date: Tue, 4 Feb 2020 14:16:26 +0000
Subject: [PATCH] Bug 22302: Make ITEMTYPECAT descriptions fallback to lib
description if no opac description
Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com>
---
C4/Koha.pm | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/C4/Koha.pm b/C4/Koha.pm
index 1cfcba6a26..39bfb4fdee 100644
--- a/C4/Koha.pm
+++ b/C4/Koha.pm
@@ -101,7 +101,7 @@ sub GetItemTypesCategorized {
SELECT itemtype, description, imageurl, hideinopac, 0 as 'iscat' FROM itemtypes WHERE ISNULL(searchcategory) or length(searchcategory) = 0
UNION
SELECT DISTINCT searchcategory AS `itemtype`,
- authorised_values.lib_opac AS description,
+ COALESCE(authorised_values.lib_opac,authorised_values.lib) AS description,
authorised_values.imageurl AS imageurl,
hideinopac, 1 as 'iscat'
FROM itemtypes
@@ -109,7 +109,7 @@ sub GetItemTypesCategorized {
WHERE searchcategory > '' and hideinopac=1
UNION
SELECT DISTINCT searchcategory AS `itemtype`,
- authorised_values.lib_opac AS description,
+ COALESCE(authorised_values.lib_opac,authorised_values.lib) AS description,
authorised_values.imageurl AS imageurl,
hideinopac, 1 as 'iscat'
FROM itemtypes
--
2.11.0