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.Dowling@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.dowling@oireachtas.ie tel: (01) 6184311 Central Enquiry Desk: Tel. 00 353 1 6184701 Email library.and.research@oireachtas.ie<mailto: library.and.research@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/beartasriomhphoistanoireachtais... _______________________________________________

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

What Koha version are you using? The table and column names have changed a bit between versions. El mié., 19 ago. 2020 a las 11:13, Patricia Dowling (< Patricia.Dowling@oireachtas.ie>) escribió:

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.dowling@oireachtas.ie tel: (01) 6184311 Central Enquiry Desk: Tel. 00 353 1 6184701 Email library.and.research@oireachtas.ie<mailto: library.and.research@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/beartasriomhphoistanoireachtais... _______________________________________________

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F