I know I could easily write a direct SQL query to show all non-deleted items that don't have an in house use before an arbitrary date, in the past six months, etc. I don't know if I could accomplish the same thing with the Evergreen reports module, though, at least without adding to the IDL.
Thomas Berezansky Assistant Network Administrator Merrimack Valley Library Consortium 4 High ST, Suite 175 North Andover, MA 01845 Phone: 978-557-8161 -----Original Message----- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Elizabeth Davis Sent: Wednesday, July 13, 2016 12:13 To: Evergreen Discussion Group <email@example.com> Subject: Re: [OPEN-ILS-GENERAL] Method for collection inventory Hello Everyone I was wondering if anyone has ever used In House Use reports for inventory instead of Status Change Date? We use Status Change Date for weeding because we don’t have circulation history past a year due to a recent migration. I can’t get the In House Use reports to provide items that have not been used. Any suggestions? Thanks, Elizabeth From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Elaine Hardy Sent: Wednesday, July 13, 2016 11:59 AM To: Evergreen Discussion Group <firstname.lastname@example.org> Subject: Re: [OPEN-ILS-GENERAL] Method for collection inventory Vince, PINES has inventory instructions at http://pines.georgialibraries.org/inventory While they are PINES specific, there are generalities that may prove useful. Elaine J. Elaine Hardy PINES & Collaborative Projects Manager Georgia Public Library Service/PINES 1800 Century Place, Ste. 150 Atlanta, GA 30045 404.235.7128 Office 404.548.4241 Cell 404.235.7201 FAX On Wed, Jul 13, 2016 at 11:41 AM, Vince Giordano <vgiord...@juniatalibrary.org <mailto:vgiord...@juniatalibrary.org> > wrote: We are planning on conducting an inventory on parts of our overall collection. We envision scanning each title. Are there web client versions of SPARK that can allow for checking item status or in-house circ? That way we could run this off of an iPad. Otherwise we would use a laptop with the staff client open and bring it around with a scanner. Any thoughts or suggestions would be helpful. Thanks! <https://s3.amazonaws.com/ucwebapp.wisestamp.com/cdbdc7d1-1136-4843-93ac-1e625844129e/vmg_12_2015.format_png.resize_200x.png> Vince Giordano Director, Juniata County Library 717-436-6378 <tel:717-436-6378> | 498 Jefferson St - Mifflintown, PA 17059 | www.facebook.com/juniatapubliclibrary <http://www.facebook.com/juniatapubliclibrary> | "Libraries will get you through times of no money better than money will get you through times of no libraries" -Anne Herbert <http://twitter.com/JuniataCoLib> <http://www.instagram.com/juniatacounty/> <https://s3.amazonaws.com/images.wisestamp.com/icons_32/linkedin.png> <http://www.pinterest.com/jocindar/> <http://ws-promos.appspot.com/ga/pixel.png?yes__count=1&e=5732568548769792> Get a signature like this: Click here! <http://ws-promos.appspot.com/r?rdata=eyJydXJsIjogImh0dHA6Ly93d3cud2lzZXN0YW1wLmNvbS9lbWFpbC1pbnN0YWxsP3dzX25jaWQ9NjcyMjk0MDA4JnV0bV9zb3VyY2U9ZXh0ZW5zaW9uJnV0bV9tZWRpdW09ZW1haWwmdXRtX2NhbXBhaWduPXByb21vXzU3MzI1Njg1NDg3Njk3OTIiLCAiZSI6ICI1NzMyNTY4NTQ4NzY5NzkyIn0=&u=757488545826125>