|
Lines 27-33
return {
Link Here
|
| 27 |
WHEN LOWER(TRIM(ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]'))) IN ('0', 'no', 'false', '') THEN 0 |
27 |
WHEN LOWER(TRIM(ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]'))) IN ('0', 'no', 'false', '') THEN 0 |
| 28 |
ELSE 0 |
28 |
ELSE 0 |
| 29 |
END |
29 |
END |
| 30 |
WHERE m.metadata LIKE '%<datafield tag="942">%'; |
30 |
WHERE m.metadata LIKE '%<datafield tag="942" %'; |
| 31 |
} |
31 |
} |
| 32 |
); |
32 |
); |
| 33 |
|
33 |
|
|
Lines 52-58
return {
Link Here
|
| 52 |
WHEN LOWER(TRIM(ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]'))) IN ('0', 'no', 'false', '') THEN 0 |
52 |
WHEN LOWER(TRIM(ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]'))) IN ('0', 'no', 'false', '') THEN 0 |
| 53 |
ELSE 0 |
53 |
ELSE 0 |
| 54 |
END |
54 |
END |
| 55 |
WHERE m.metadata LIKE '%<datafield tag="942">%'; |
55 |
WHERE m.metadata LIKE '%<datafield tag="942" %'; |
| 56 |
} |
56 |
} |
| 57 |
); |
57 |
); |
| 58 |
|
58 |
|
|
Lines 66-71
return {
Link Here
|
| 66 |
); |
66 |
); |
| 67 |
|
67 |
|
| 68 |
say $out "Set the 942\$n => biblio.opac_suppressed mapping for all MARC frameworks"; |
68 |
say $out "Set the 942\$n => biblio.opac_suppressed mapping for all MARC frameworks"; |
| 69 |
say_warning( $out, "You need to run the `maintenance/touch_all_biblios.pl` script" ); |
69 |
say_warning( |
|
|
70 |
$out, |
| 71 |
"The biblio.opac_suppressed column should be updated, but you can run the `maintenance/touch_all_biblios.pl` script to be certain" |
| 72 |
); |
| 70 |
}, |
73 |
}, |
| 71 |
}; |
74 |
}; |
| 72 |
- |
|
|