itype is in the items table. Join items using (itemnumber) and just use
itype instead of i.itype.
On 5/20/22 9:50 AM, Alvaro Cornejo wrote:
Hi
I your SQL 'i.itype' "i"is not a table so I guess you need to use
"biblio.itype"
Not sure you need to also use <<Item type|biblio.itemtypes>>
You might need to check database structure at
https://schema.koha-community.org/ for exact field table/column names
Regards
Alvaro
|----------------------------------------------------------------------------------------|
Stay safe / Cuídate/ Reste sécurisé
*7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à
mesure.
*q *Recycle always / Recicla siempre / Recyclez toujours
P Print only if absolutely necessary / Imprime solo si es necesario /
Imprimez seulement si nécessaire
Le ven. 20 mai 2022 à 01:57, Ma. Victoria H. Silva-Manuel <
[email protected]> a écrit :
Hi.
I am using the SQL report below for our click tracker:
SELECT count(*) AS 'No. of Times Clicked', biblio.title AS 'Title', URL
FROM linktracker
JOIN biblio USING(biblionumber)
WHERE date(timeclicked) BETWEEN <<Date BETWEEN (yyyy-mm-dd)|date>> AND
<<and (yyyy-mm-dd)|date>>
GROUP BY url
I want to add item type filter, so I tried to add it to WHERE clause:
SELECT count(*) AS 'No. of Times Clicked', biblio.title AS 'Title', URL
FROM linktracker
JOIN biblio USING(biblionumber)
WHERE date(timeclicked) BETWEEN <<Date BETWEEN (yyyy-mm-dd)|date>> AND
<<and (yyyy-mm-dd)|date>> AND i.itype = <<Item type|itemtypes>>
GROUP BY url
But I'm getting the following error:
*The following error was encountered:*
The database returned the following error:
Unknown column 'i.itype' in 'where clause'
Please check the log for further details.
What am I doing wrong?
--
Ma. Victoria H. Silva-Manuel
Registered Librarian, 3892
_______________________________________________
Koha mailing listhttp://koha-community.org
[email protected]
Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing listhttp://koha-community.org
[email protected]
Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
--
*Tim McMahon*
West Liberty Public Library
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
