So you want what Ian said: SELECT biblionumber FROM biblio_metadata WHERE ExtractValue(metadata, '//datafield[@tag="440"]/subfield[@code="a"]') LIKE '%Irish Office pamphlets%';
El mié., 19 ago. 2020 a las 12:20, Patricia Dowling (< patricia.dowl...@oireachtas.ie>) escribió: > Hi Tomas, > > It’s 19.11.07 > > > > > > > > > > > > > > *From:* Tomas Cohen Arazi <tomasco...@gmail.com> > *Sent:* Wednesday 19 August 2020 16:19 > *To:* Patricia Dowling <patricia.dowl...@oireachtas.ie> > *Cc:* koha@lists.katipo.co.nz > *Subject:* Re: [Koha] SQL help > > > > 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.dowl...@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.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 > <https://smex12-5-en-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=https%3a%2f%2flists.katipo.co.nz%2fmailman%2flistinfo%2fkoha&umid=fdc66489-3523-4c07-b776-757a0b7c0ddd&auth=43ff9ca5824af5fcf2ab3da15bfea1b8c1c54367-00ae457d2fd400a1e81cdeaa60b5a51fcc5dd46d> > > > > > -- > > Tomás Cohen Arazi > > Theke Solutions (http://theke.io > <https://smex12-5-en-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=http%3a%2f%2ftheke.io&umid=fdc66489-3523-4c07-b776-757a0b7c0ddd&auth=43ff9ca5824af5fcf2ab3da15bfea1b8c1c54367-81254ffb49f88c3b1c1a377ab640d5b93bb87c79> > ) > ✆ +54 9351 3513384 > GPG: B2F3C15F > > ------------------------------ > > 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/ > -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
