https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32033
--- Comment #5 from Chaminda de Silva <[email protected]> --- (In reply to David Cook from comment #3) > (In reply to Chaminda de Silva from comment #2) > > 1. How to findout the URL of the particulaar record. > > Do you mean how do you determine which record is causing the problem? > > You'll need to do a SQL Report. > > You could try something like the following: > > SELECT biblionumber, ExtractValue(metadata,'//datafield[@tag="880" and > subfield[@code="6" and substring(text(),1,3)="24 "]]/*') as f880 from > biblio_metadata HAVING f880 <> '' > > Do you have a public OPAC? If you can provide the URL to that OPAC, I can > lookup the records once you've given me a biblionumber. Thank you very much David, I figured out the problem of Tag "24 " is not a valid tag using your SQL Query. It should be Tag "245" not Tag "24 ". -- 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/
