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 <[email protected]> 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 > *[email protected] <[email protected]>* > > *Please contact [email protected] <[email protected]> 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 > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Best, ERIC PHETTEPLACE Systems Librarian (he/him) [email protected] | o 510.594.3660 5212 Broadway | Oakland, CA | 94618 :(){ :|: & };: _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
