Re: [Koha] SQL statement for generating current checkouts

2011-04-26 Thread nabon...@jncasr.ac.in
x27;m not sure if this sort of result can be generated in Koha. 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 Email: nabon...@jncasr.ac.i

Re: [Koha] SQL statement for generating current checkouts

2011-04-29 Thread nabon...@jncasr.ac.in
Email: nabon...@jncasr.ac.in Web: http://lib.jncasr.ac.in At Thursday, 21-04-2011 on 5:52 pm Church, Beverly wrote: 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