[Koha] Report help needed for List of Items added by cataloger with link to biblio title

Vimal Kumar V. vimal0212 at gmail.com
Sat Dec 14 08:34:30 NZDT 2013


Dear Friends,
I made some changes in the report with title "Titles added by cataloger"
from SQL Report Library.
My aim is to build a report which list of biblios added by cataloguer.
Now this report display time stamp and biblio number with link.
I request your help to add bibio.title in this report.

SELECT
      timestamp AS 'titles added',
      CONCAT('<a
href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',object,'\">',object,'</a>')
AS Biblionumber
FROM action_logs
WHERE module='CATALOGUING' AND user=<<Borrower number>>
      AND info!='item' AND action='ADD'


Regards,
-- 
Vimal Kumar V.
Technical Assistant
Mahatma Gandhi University Library
Kottayam, Kerala- 686 560
Web: http://www.vimalkumar.info
Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
---------------------------------------------------------------------------
"I forget what I was taught. I only remember what I have learnt"
-Patrick White


More information about the Koha mailing list