| Summary: | couldn't view biblio.author on reports | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Nishath Ahmed <nishathahmed> |
| Component: | Reports | Assignee: | Bugs List <koha-bugs> |
| Status: | CLOSED INVALID | QA Contact: | Testopia <testopia> |
| Severity: | normal | ||
| Priority: | P5 - low | CC: | jonathan.druart, nishathahmed |
| Version: | 20.11 | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
| Attachments: | Koha-report | ||
This is a support question, please ask the mailing list https://koha-community.org/support/koha-mailing-lists/ |
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