[Koha] Click Tracker

[Alvaro Cornejo]

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 <
mavicsilva at gmail.com> 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 list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>