Hi Aleisha and all, Thank you so much for your help. It helped my problem.
Thanks a million. Very Warm Regards James On Tue, 3 Aug 2021 00:07 Aleisha Amohia, <[email protected]> wrote: > Hi Muiru > > Your query is almost there! I think your error is happening because of the > columns you're joining the tables on. The joining column should be equal > (or represent the same data) in both tables to be accurate. You should > amend the query to look more like: > > SELECT items.itemcallnumber, items.barcode, biblio.author,biblio.title, > biblioitems.publishercode AS ISBN, items.price > FROM items > LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber) > LEFT JOIN biblioitems ON (biblioitems.biblionumber=items.biblionumber) > LEFT JOIN biblio_metadata ON > (items.biblionumber=biblio_metadata.biblionumber) > > Hopefully that gives you some data in your results. > > Also just noticed that you're using biblioitems.publishercode as ISBN, I'm > sure you know this, but there is also a biblioitems.isbn field that might > be mapped more accurately for you to use for this purpose. > > Hope that helps! > > Aleisha > On 2/08/21 9:40 pm, muiru james wrote: > > Hello team, > > I recently reinstalled koha 20.05 on Ubuntu 20. I'm running a complete > shelflist report with columns biblio.author, biblio.title. However for new > items added to the records, columns for author and title are blank. I have > tried to use the extractvalue from biblio_metadata and the result is the > same. > > The query is as below: > > SELECT > items.itemcallnumber, items.barcode, biblio.author,biblio.title, > biblioitems.publishercode AS ISBN, items.price. > From items > LEFT JOIN biblio ON (biblio.biblionumber=items.itemnumber) > LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=biblionumber) > LEFT JOIN biblio_metadata ON (items.itemnumber=biblio_metadata.biblionumber) > > Records staged after installation has the details but new items added ti > the existing records has only data from the items table- callnumber, > barcode and price. > > During the installation process, i could not install mariadb directly n had > to install the mariadbserver10.03 then mariadbclient-10.03 then > mariadbserver. > > I have tried rebuilding zebra and also rebuilding the tables from > therebuildtables.pl without success. > > Any help will be greatly appreciated. > > Regards > James > _______________________________________________ > > Koha mailing list http://[email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > -- > *Aleisha Amohia*(she/her) > Koha Developer > > Catalyst IT - Expert Open Source Solutions > Tel: +64 4 499 2267 | www.catalyst.net.nz > > [image: Catalyst Logo] > > CONFIDENTIALITY NOTICE: This email is intended for the named recipients > only. It may contain privileged, confidential or copyright information. If > you are not the named recipient, any use, reliance upon, disclosure or > copying of this email or its attachments is unauthorised. If you have > received this email in error, please reply via email or call +64 4 499 2267. > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
