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 <[email protected]> Sent: Tuesday, January 12, 2016 7:52 AM To: Chris Cormack; M Waqar Aslam Cc: [email protected] 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 <[email protected]> on behalf of Chris Cormack <[email protected]> Sent: Saturday, January 9, 2016 12:42 AM To: M Waqar Aslam Cc: [email protected] Subject: Re: [Koha] Issue Report On 9 January 2016 at 00:35, M Waqar Aslam <[email protected]> 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 [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
