[Koha] Barcode as a link report

[muiru james]

Hello Mark,

Following up on this query, this is the whole SQL query

SELECT CONCAT('<a href=\"/cgi-bin/koha/cataloguing/
additem.pl?op=edititem&biblionumber=', biblionumber, '&itemnumber=',
itemnumber, '#edititem', '\">', itemnumber, '</a>' ) AS
itemnumber,items.itemcallnumber,items.barcode,biblio.author,biblio.title,items.price

FROM items
LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)
WHERE items.barcode NOT LIKE 'K%'
AND  items.barcode NOT LIKE 'A%'
AND items.barcode NOT LIKE 'B%'
AND items.itype=<<itype|itemtypes>>
ORDER BY items.itemcallnumber asc

The error is as under:

*The following error was encountered:*
The database returned the following error:
Column 'biblionumber' in field list is ambiguous
Please check the log for further details.
Return to previous page
<http://127.0.1.1:8080/cgi-bin/koha/reports/guided_reports.pl?reports=37&phase=Run+this+report&param_name=itype%7Citemtypes&sql_params=BK#>

If I remove author and title fields, the report runs well. I however would
need the two fields.

Warm Regards

On Tue, May 19, 2020 at 2:28 PM Mark Alexander <marka at pobox.com> wrote:

> Excerpts from muirunyeri's message of 2020-05-19 11:10:33 +0300:
> > However if anybody would help me understand why I get an error
> (biblionumber is ambiguous) after adding any field from biblio table I'd be
> really grateful. This after correctly adding a left join for the biblios
> table using biblionumber on itemnumber in items.
>
> It would help if you could post your entire query.  But my guess is
> that the ambiguity is the result of joining two tables that have
> fields with the same name.  The items and biblio tables both have a
> field called biblionumber.  So in your query, you have to fix the
> ambiguity by using the table name as a prefix: e.g.,
> items.biblionumber or biblio.biblionumber .
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>