You didn't mention your koha version. That's kinda necessary info if you are trying to extract from marcxml
-indranil On Wed, 19 Aug, 2020, 7:42 pm Patricia Dowling, < patricia.dowl...@oireachtas.ie> wrote: > > I wonder if anyone in the community can steer me on this basic SQL query? > I am a very novice SQL user so apologies in advance! > > I want to get a list of bibnumbers for all records with a value of “Irish > Office pamphlets” in the 440a tag (series) with title, author and > publication date so that I can export this list to excel as a csv file. > > I have had a look around the Reports Library but got bogged down between > the various tables biblio, items, marcxml etc.) > > Thanks in advance! > Patricia > > > > Patricia Dowling, > Research Librarian, > Oireachtas Library & Research Service, > Leinster House, > Dublin 2, > Ireland > patricia.dowl...@oireachtas.ie > tel: (01) 6184311 > Central Enquiry Desk: Tel. 00 353 1 6184701 > Email library.and.resea...@oireachtas.ie<mailto: > library.and.resea...@oireachtas.ie> > > > > > > > > > > > > > ________________________________ > > Oireachtas email policy and disclaimer. > http://www.oireachtas.ie/parliament/about/oireachtasemailpolicyanddisclaimer/ > > > Beartas ríomhphoist an Oireachtais agus séanadh. > http://www.oireachtas.ie/parliament/ga/eolas/beartasriomhphoistanoireachtaisagusseanadh/ > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
