https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39082
--- Comment #2 from Andrew Fuerste-Henry <[email protected]> --- (In reply to Jonathan Druart from comment #1) > Could you provide us with some examples of false positives? Maybe we can > refine the regex and don't report the alert if we catch import_records? > Would that be enough? I ran into this on a report to compare values in a staged MARC batch to the values in the records to which they matched or which they created: SELECT ib.title as import_title, coalesce(ib.isbn,ib.issn) as import_isbn_issn, SUBSTRING(ExtractValue(import_records.marcxml,'//leader'),7,1) as import_leader_06, extractvalue(import_records.marcxml,'//controlfield[@tag="007"]') as import_007, b.biblionumber, b.title, b.subtitle, b.author, b.frameworkcode, coalesce(biblioitems.isbn,biblioitems.issn) as record_isbn_issn, SUBSTRING(ExtractValue(metadata,'//leader'),7,1) AS leader_06, extractvalue(metadata,'//controlfield[@tag="007"]') as 007_tags FROM import_batches LEFT JOIN import_records using (import_batch_id) left join import_biblios ib using (import_record_id) LEFT JOIN biblio b ON (ib.matched_biblionumber = b.biblionumber) LEFT JOIN biblio_metadata USING (biblionumber) LEFT JOIN biblioitems USING (biblionumber) WHERE import_batch_id= <<Import batch id>> -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
