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 <<Date BETWEEN (yyyy-mm-dd)|date>> AND > <<and (yyyy-mm-dd)|date>> GROUP BY url I want to add a drop down list for item type. I tried adding items.itype=<<itype|itemtypes>> 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
