[Koha] Help with Query on Modification lof for patrons and fines

[Nicole Engard]

There is a report that does just that listed on this page:

http://wiki.koha.org/doku.php?id=sql_library

it's this one:

SELECT  borrowers.cardnumber, borrowers.surname, borrowers.firstname,

        FORMAT(SUM(accountlines.amountoutstanding),2) as due
FROM borrowers LEFT JOIN accountlines ON
(borrowers.borrowernumber=accountlines.borrowernumber)
WHERE accountlines.amountoutstanding > 0
GROUP BY borrowers.cardnumber

ORDER BY borrowers.surname ASC



2009/8/10 Akin Adigun <akinomatics at yahoo.com>

>  Hello,
> I am using koha 3.0.1 on suse 11.0 with nozebra configuration
>
> Pls I need queries on modification log for patrons and queries on patron
> that have fine againt there record and having fine above the nochage amount
>
> thanks
>
> Akin Adigun *(MCP)*
> Akinomatics
> Tel: +2348035565348, +2348029219271
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090810/52fbc15a/attachment-0001.htm