[Koha] Reporting on 942$c

[Eric Phetteplace]

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 at 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 at york.edu <jcoehoorn at york.edu>*
>
> *Please contact helpdesk at york.edu <helpdesk at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Best,

ERIC PHETTEPLACE Systems Librarian (he/him)

ephetteplace at cca.edu | o 510.594.3660

5212 Broadway | Oakland, CA | 94618

:(){ :|: & };: