Re: [Koha] Interesting report request

2014-03-31 Thread Nicole Engard
On Mon, Mar 31, 2014 at 11:33 AM, Katelyn Browne wrote: > SELECT borrowernumber, GROUP_CONCAT(items.itemcallnumber, " ( ", > biblio.title, ") ") AS booklist > FROM (SELECT borrowernumber > FROM statistics > WHERE date(statistics.datetime) BETWEEN <> > AND <> > AND statistics.type='return' >

Re: [Koha] Interesting report request

2014-03-31 Thread Katelyn Browne
I would start by pulling the set of patrons who checked in today or yesterday, then pull the books from their account that fit the due date range. Here's a start; it functions, but I haven't checked to see if it's pulling all the right information. It should return a list of outstanding call number

[Koha] Interesting report request

2014-03-31 Thread Nicole Engard
I think this can be done - but I'm not sure how to tackle it. I got this request for a report to find items that probably got missed at checkin so the staff can go look to the shelves to find these items. The question was - could we take the set of patrons who had items due during a three day per