[Koha] Report generation
Hello Any one know how to create report in sql, of your collection that has Tag 521 and 526 in your output. Thank you! ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Click Tracker
Thank you for responding, unfortunately it still didn't work. On Mon, Mar 27, 2023, 9:32 PM Alvaro Cornejo wrote: > Hi Victoria > > > I don't recall koha's tables content, but in mysql the dot delimit column > and table. Therefore, items.itype means column "items" from table "itype" > and in your query you are not calling table itype. > > So you can add a join with itype table or, if column "items" exist, in > linktracker or biblio tables, you can use items.linktracker > =<> or items.biblio=<> > > 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 lun. 27 mars 2023 à 00:31, Ma. Victoria H. Silva-Manuel < > mavicsi...@gmail.com> a écrit : > >> I am using this SQL to generate Click Tracker report: >> >> SELECT count(*) AS 'No. of Times Clicked', biblio.title AS 'Title', URL >> > FROM linktracker >> > >> JOIN biblio USING(biblionumber) >> >> WHERE date(timeclicked) BETWEEN <> AND >> > <> >> >> GROUP BY url >> >> >> I want to add a drop down list for item type. I tried >> adding items.itype=<> in WHERE part, but I'm getting the >> following error when I run the report: >> >> The following error was encountered: >> > The database returned the following error: >> > Unknown column 'items.itype' in 'where clause' >> > Please check the log for further details. >> >> >> What should I do? >> >> >> -- >> Ma. Victoria H. Silva-Manuel >> Registered Librarian, 3892 >> ___ >> >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] koha-US April 2023 Events & Meetings
Hello! koha-US online meetings and events are free and open to all. See our calendar for a full list: http://koha-us.org/calendar/. For Google Calendar users, add our events calendar to your list for easy access to meeting times and links: https://calendar.google.com/calendar/u/1?cid=a29oYS11cy5vcmdfZG1xb2pkczE5ZnU4bDhiZDZyb2dlajluNDhAZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ *Meetings* Board Meeting - Wednesday, April 5 @ 8:30a PT / 11:30a ET / 15:30 UTC General Meeting - Wednesday, April 12 @ 8:30a PT / 11:30a ET / 15:30 UTC *Special Interest Groups* Cataloging - Thursday, April 6 @ 8:00a PT / 11:00a ET / 15:00 UTC System Administration - Tuesday, April 11@ 8:00a PT / 11:00a ET / 15:00 UTC Acquisitions - Tuesday, April 18 @ 9:00a PT / 12:00p ET / 16:00 UTC Web Development - Thursday, April 20 @ 10:00a PT / 1:00p ET / 17:00 UTC Cataloging - Thursday, April 27 @ 1:00p PT / 4:00p ET / 20:00 UTC Circulation - on hiatus Demonstration Instance - on hiatus Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topic-specific mailing lists. Most meetings and events are recorded and made available at https://www.youtube.com/kohaus Jennifer Marlatt koha-US Secretary secret...@koha-us.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Click Tracker
Hi Victoria I don't recall koha's tables content, but in mysql the dot delimit column and table. Therefore, items.itype means column "items" from table "itype" and in your query you are not calling table itype. So you can add a join with itype table or, if column "items" exist, in linktracker or biblio tables, you can use items.linktracker =<> or items.biblio=<> 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 lun. 27 mars 2023 à 00:31, Ma. Victoria H. Silva-Manuel < mavicsi...@gmail.com> a écrit : > I am using this SQL to generate Click Tracker report: > > SELECT count(*) AS 'No. of Times Clicked', biblio.title AS 'Title', URL > > FROM linktracker > > > JOIN biblio USING(biblionumber) > > WHERE date(timeclicked) BETWEEN <> AND > > <> > > GROUP BY url > > > I want to add a drop down list for item type. I tried > adding items.itype=<> in WHERE part, but I'm getting the > following error when I run the report: > > The following error was encountered: > > The database returned the following error: > > Unknown column 'items.itype' in 'where clause' > > Please check the log for further details. > > > What should I do? > > > -- > Ma. Victoria H. Silva-Manuel > Registered Librarian, 3892 > ___ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
