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