[Koha] SQL query: Who has issued the '1234' barcoded book? and when?

vishal patil vishal.patil at osslabs.biz
Tue Feb 4 17:59:05 NZDT 2014


Please find below the report which we are using to check the actions taken
in our library, it is datewise report in descending order:


CONCAT('<a href=\"/cgi-bin/koha/reports/
\">Checkout Details</a>'), IF(a.action="RETURN",CONCAT('<a
\"  >Checkin Details</a>'),a.info)


 from action_logs a

left join borrowers b ON (b.borrowernumber=a.user)

where  (a.module="MEMBERS" OR (a.action="ISSUE" OR a.action="RETURN" ))
AND  timestamp between<<From date:yyyy-mm-dd>>AND<<To date:yyyy-mm-dd>>
ORDER BY  a.timestamp DESC

hope this helps you!!!!!!!!!

On Tue, Feb 4, 2014 at 9:04 AM, HRS <bala.allmail at gmail.com> wrote:

> Hi
> Please help me to find solutions  bellow matter
> Recently  our library had  a problem of  issuing a few books to  wrong
> patrons' name by  a staff member in circulation counter (  nearly  15
> staff member work in the desk in   time to time /month as we have
> roster based duties in the counter)
> In looking SQL queries for
> 1. Who has issued  the given barcoded book? and when?
> 2. What  are the books issued by staff-ID( with time) ?
> Harsha Balasooriya
> Senior Assistant Librarian, Systems
> The Open University of Sri Lanka
> Tel: 011-2881030
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

Vishal Patil
Landline number:02232080161
*vishal_wpatil at nucsoft.co.in <vishal_wpatil at nucsoft.co.in>*
          *vishal.patil at osslabs.biz <vishal.patil at osslabs.biz>.*

More information about the Koha mailing list