[Koha] Report help

[Liz Rea]

Hi,

Try this:

SELECT biblio.title, biblio.author, items.itemcallnumber, lcsh FROM
(SELECT biblionumber,
ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]') AS
lcsh FROM biblioitems) AS subjects JOIN biblio USING(biblionumber) JOIN
items USING(biblionumber) WHERE lcsh LIKE "%KEYWORD%";


On 06/10/15 23:45, Charlotte Stock wrote:
> This must be simple to fix but I'm not fluent enough in Koha-speak to crack the problem. Would anyone be able to help amend this SQL report, so that the results show the title, author and call number for each entry, instead of a hyperlinked biblionumber?
>
> All suggestions gratefully received!
>
>
>
> Charlotte Stock
> Librarian
> charlotte at bu-london.co.uk<mailto:charlotte at bu-london.co.uk>
>
> Boston University Study Abroad London
> 43 Harrington Gardens
> London, SW7 4JU
> T 0207 244 6255   F 0207 373 9430
> http://www.bu.edu/london/
>
> Registered company in England no. FC020819
> ---------------------------------------------------------------------------------------
> This email message has been delivered safely and archived online by Mimecast.
> For more information please visit http://www.mimecast.com 
> ---------------------------------------------------------------------------------------
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: OpenPGP digital signature
URL: <https://lists.katipo.co.nz/pipermail/koha/attachments/20151007/c2565952/attachment-0001.sig>