[Koha] Issue Report

[M Waqar Aslam]

Thank you very  much Sir for your response on my query.  I am requesting to you   compile a complete SQL reports which are mostly using in Libraries.  Here is enough data available on  http://wiki.koha-community.org/wiki/SQL_Reports_Library but mostly SQL queries is not working. Thanks





Muhammad Waqar Aslam
Air University

________________________________________
From: Sher Afzal <libsolisb at outlook.com>
Sent: Tuesday, January 12, 2016 7:52 AM
To: Chris Cormack; M Waqar Aslam
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Issue Report

Dear Mr Waqar Aslam

Please find below the Sql Reports as desired. As this version is too old i recommend to use the latest version of koha or please contact with me for the latest Full Stack Latest version koha live DVD.

Please copy and past the following command in SQL box.

SELECT statistics.datetime AS 'Issue Date', borrowers.surname,borrowers.firstname, borrowers.cardnumber, items.barcode, biblio.title FROM borrowers
LEFT JOIN statistics ON (statistics.borrowernumber=borrowers.borrowernumber)
LEFT JOIN items ON (items.itemnumber = statistics.itemnumber)
LEFT JOIN biblio ON (biblio.biblionumber = items.biblionumber)
WHERE statistics.type='issue'
AND date(statistics.datetime)
BETWEEN <<Item issued BETWEEN (yyyy-mm-dd)|date>>
AND <<and (yyyy-mm-dd)|date>>
AND statistics.branch= <<Select library|branches>>
ORDER BY borrowers.surname ASC


Regards
SHER AFZAL
Chief Librarian
Bahria University

________________________________________
From: Koha <koha-bounces at lists.katipo.co.nz> on behalf of Chris Cormack <chris at bigballofwax.co.nz>
Sent: Saturday, January 9, 2016 12:42 AM
To: M Waqar Aslam
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Issue Report

On 9 January 2016 at 00:35, M Waqar Aslam <waqaraslam87 at live.com> wrote:
> Dear Colleagues !
>
>  I hope all you are doing well. we are using KOHA version 3.04.02. We have  started for Circulation. Now i want to create issue report From 01-01-2015 to 31-12-2015. Please if any have query about then please send. Thanks
>
>
>
Hi Waqar

Was that a typo? Are you really using 3.04.02? That was released in
Jun 2011 ... 4.5 years ago. I doubt anyone will be able to give you
much help for a version that old.
The database structure for circulation has changed quite a lot since then.

Chris
_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha