Dear Koha users/Developers,
Can you please help me in building SQL statement to generate current
checkouts on a given date (not for a date range). For example, I need to
generate a report to get list of (barcodes with borrowers card number,
surname and firstname and borrower's category with date o
Nabonita,
You can use this query if you want to see the title:
SELECT issues.issuedate, items.barcode, biblio.title,
borrowers.firstname,borrowers.surname, borrowers.cardnumber,
borrowers.categorycode FROM issues LEFT JOIN borrowers ON
borrowers.borrowernumber = issues.borrowernumber LEFT JOIN it
Hi Nabonita,
Try this query. It looks for any items that are current checked out where
the checkout date was on or before 2011-03-29, or the last renewal date was
or before 2011-03-29.
SELECT issues.issuedate, items.barcode, biblio.title,
borrowers.firstname,borrowers.surname, borrowers.cardnumbe
Thanks Beverly for send me the SQL query. But this is retrieving only
those titles which are issued on the given date. Where as I need to
know that the titles which were on loan AS OF 2011-03-29. This may
contain overdue books, and books which were issued/renewed on or
before the given date. I'm no
11:35:49 PM
To: "Church, Beverly"
Cc: "koha@lists.katipo.co.nz"
Subject: Re: [Koha] SQL statement for generating current checkouts
Thanks Beverly for send me the SQL query. But this is retrieving only those
titles which are issued on the given date. Where as I need to know
Hi Beverly,
Thanks for the SQL statement. This is the output what I was looking
for.
With regards
Nabonita
--
Nabonita Guha
Library-cum-Information Officer
Library, Jawaharlal Nehru Centre
for Advanced Scientific Research,
Jakkur Post, Bangalore 560064
Karnataka, India
Phone: +91-80-22082930
E
6 matches
Mail list logo