Bug 27302 - couldn't view biblio.author on reports
Summary: couldn't view biblio.author on reports
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: 20.11
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-12-23 07:37 UTC by Nishath Ahmed
Modified: 2021-12-13 21:10 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Koha-report (97.66 KB, application/pdf)
2020-12-23 07:37 UTC, Nishath Ahmed
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nishath Ahmed 2020-12-23 07:37:03 UTC
Created attachment 114662 [details]
Koha-report

hi There,
I just want to take report of item bar code and author of book. I can get barcode and failed to fetch author by executing following SQL

SELECT items.barcode, biblio.author FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)  GROUP BY items.barcode,biblio.author.

I get empty column on author when I execute this SQL statement. I entered my catalogue entry on fast add framework with statement of responsibility as author.
But still no luck. You can refer attachments of output. Correct me if I am wrong or raise as bug.

Thanks!
Nishath
Comment 1 Jonathan Druart 2021-01-05 07:00:09 UTC
This is a support question, please ask the mailing list
https://koha-community.org/support/koha-mailing-lists/