27 Mar
2023
27 Mar
'23
7:30 a.m.
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