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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha