Hi Joel, The full MARCXML record is available in the metadata field of the biblio_metadata table. You need to use that table in your query and an ExtractValue function to get the particular subfields you’re interested in. I would recommend looking at the Reports library in the wiki which should be linked in the sidebar of Reports. Best, Eric On Tue, Dec 10, 2019 at 07:30 Coehoorn, Joel <jcoehoorn@york.edu> wrote:
I'm working on a report, and I'd like to see data related to the 942$c field. We want to look at instances where it's different than 952$y, and validate these. Where (if anywhere) is this field stored in the database? I can't find it. It doesn't seem to always match either item.itype or biblioitem.itemtype.
Joel Coehoorn Director of Information Technology 402.363.5603 *jcoehoorn@york.edu <jcoehoorn@york.edu>*
*Please contact helpdesk@york.edu <helpdesk@york.edu> for technical assistance.*
The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Best, ERIC PHETTEPLACE Systems Librarian (he/him) ephetteplace@cca.edu | o 510.594.3660 5212 Broadway | Oakland, CA | 94618 :(){ :|: & };: