View | Details | Raw Unified | Return to bug 38330
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_38330.pl (-4 / +6 lines)
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
- 

Return to bug 38330