Hi Katrin,
Thanks alot. It really helps and solves my case.
Most appreciated.
Warm regards
James
On Fri, May 29, 2020 at 11:59 PM Katrin Fischer
wrote:
> Hi,
>
> you have 2 tables in your query that both have a biblionumber column:
> items and biblio.
>
> So in your query, you need to
Hi,
you have 2 tables in your query that both have a biblionumber column:
items and biblio.
So in your query, you need to specifiy which table is meant by adding
the name of the table it should use:
SELECT CONCAT('', itemnumber, '' ) AS
Hello Mark,
Following up on this query, this is the whole SQL query
SELECT CONCAT('', itemnumber, '' ) AS
itemnumber,items.itemcallnumber,items.barcode,biblio.author,biblio.title,items.price
FROM items
LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN
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
(GMT+03:00) To: koha
Subject: Re: [Koha] [koha] Barcode as a link report
Excerpts from muirunyeri's message of 2020-05-18 13:05:56 +0300:
> I'm looking to create a report with barcode as a link that when will clicked
> will open the edit items page.
There are some examples here that migh
Excerpts from muirunyeri's message of 2020-05-18 13:05:56 +0300:
> I'm looking to create a report with barcode as a link that when will clicked
> will open the edit items page.
There are some examples here that might help:
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Links_by_item
Hello team
I hope you all keeping safe
I'm looking to create a report with barcode as a link that when will clicked
will open the edit items page.
Kindly assist.
Warm Regards James
Sent from my Samsung Galaxy smartphone.
___
Koha mailing list
7 matches
Mail list logo