[Koha] Click Tracker

[Tim McMahon]

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 <
> 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 listhttp://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> _______________________________________________
>
> Koha mailing listhttp://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
-- 
*Tim McMahon*
West Liberty Public Library