[Koha] SQL help

[Tomas Cohen Arazi]

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.Dowling at oireachtas.ie>) escribió:

> Hi Tomas,
>
> It’s 19.11.07
>
>
>
>
>
>
>
>
>
>
>
>
>
> *From:* Tomas Cohen Arazi <tomascohen at gmail.com>
> *Sent:* Wednesday 19 August 2020 16:19
> *To:* Patricia Dowling <Patricia.Dowling at oireachtas.ie>
> *Cc:* koha at 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.Dowling at 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 at oireachtas.ie
> tel: (01) 6184311
> Central Enquiry Desk: Tel. 00 353 1 6184701
> Email library.and.research at oireachtas.ie<mailto:
> library.and.research at 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 at 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