From 19df7b7801c82b795cf8d49101e7c438210f7d57 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Thu, 8 May 2025 17:16:35 +0100 Subject: [PATCH] Bug 38330: (QA follow-up) Correction to field extaction As pointed out by David.. it's the 942 not the 952 we have this data in. Signed-off-by: Martin Renvoize --- installer/data/mysql/atomicupdate/bug_38330.pl | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_38330.pl b/installer/data/mysql/atomicupdate/bug_38330.pl index 9e04f141b28..73eaba9d516 100755 --- a/installer/data/mysql/atomicupdate/bug_38330.pl +++ b/installer/data/mysql/atomicupdate/bug_38330.pl @@ -22,11 +22,11 @@ return { JOIN biblio_metadata m ON b.biblionumber = m.biblionumber SET b.opac_suppressed = CASE - WHEN ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]') REGEXP '^[01]$' THEN - ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]') + WHEN ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]') REGEXP '^[01]$' THEN + ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]') ELSE 0 END - WHERE m.metadata LIKE '%%'; + WHERE m.metadata LIKE '%%'; } ); @@ -47,11 +47,11 @@ return { JOIN deletedbiblio_metadata m ON b.biblionumber = m.biblionumber SET b.opac_suppressed = CASE - WHEN ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]') REGEXP '^[01]$' THEN - ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]') + WHEN ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]') REGEXP '^[01]$' THEN + ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]') ELSE 0 END - WHERE m.metadata LIKE '%%'; + WHERE m.metadata LIKE '%%'; } ); -- 2.49.0