Hi all,
I'm trying to get the barcodes column from the items database to display on the
results page after running the following SQL query:
SELECT CONCAT('<a
href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',biblionumber,'</a>')
AS bibnumber, lcsh
FROM
(SELECT biblionumber,
ExtractValue(marcxml,'//datafield[@tag="690"]/subfield[@code>="a"]')
AS lcsh FROM biblioitems)
AS subjects
WHERE lcsh
LIKE <<Enter keyword surrounded BY %>>
WHERE biblionumber.biblionumber=items.barcode
The above I found on the Koha SQL library, but this query only displays the
biblionumber and keyword query results in 690a. I'd like to add the barcodes
column to the report. Can't seem figure out how to do this in this query. Help,
please :)
Many thanks!
C
Craig Butosi, MA, MLIS, B Mus (Hons.)
LIBRARY SERVICES MANAGER
the royal conservatory
TELUS Centre for Performance and Learning
273 Bloor Street West
Toronto, ON M5S 1W2
416.408.2824 x338
www.rcmusic.ca<http://www.rcmusic.ca/>
Note: This email message and any attachments are intended only for the use of
the individual to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law. If
the recipient of this email is not the intended recipient (or the employee or
agent responsible for delivering the email to the intended recipient), you are
hereby notified that any review, dissemination, distribution or copying or
other use of this message is strictly prohibited. If you have received this
communication in error, please notify the sender immediately by return email
and delete this message and attachments from your system, thank you.
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
