1 Feb
2021
1 Feb
'21
3:25 a.m.
Good day. I am using the SQL report below to track clicks from tag 856$u SELECT count(*) AS 'No. of Times Clicked', biblio.title AS 'Title',
CONCAT(borrowers.firstname, ' ',borrowers.surname) AS 'Patron', URL FROM linktracker
JOIN biblio USING(biblionumber)
JOIN borrowers USING(borrowernumber)
WHERE date(timeclicked) BETWEEN '2021-01-01' AND '2021-01-31'
GROUP BY url
The above report only shows the links clicked by log in users. When I delete the concat, it shows the links clicked by all users but does not show the names of logged in users. Is there a way to create a report that will show links clicked by all users and show the names if the users are logged in? Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892