From Create Lists, create a query of Items with the following status: Billed, Lost and Paid, Missing, Claimed Returned, and Discard which have been out of circulation for more than 3 years. Use this list to determine which items should be deleted from the catalog.
Find an empty Review File and click on the search Records button. The Query box will open. Set the Record Type to Item, since those are the types of records you are requesting. Leave Range set as it is (to search the broadest set of records possible) and start to build your query.
Leave Range set as it is (to search the broadest set of records possible) and start to build your query.
Limit to your library’s items by limiting to items where the Location is your library. With your library set, click on Append Line to add additional criteria to your query.
Set the Type to Item, Field to LOUTDATE (this represents the Last Out Date in Sierra), and then set the date with the Condition and Value A. Set the Condition to Less than, since you are looking for any item record whose last out date is before the date you set in Value A, this date should be a date roughly three years before the current date.
You will want to limit the list to items that have certain statuses (Billed, Lost and Paid, Missing, Claimed Returned, and Discard) that you may decide to delete from the library catalog.
Make sure to Group the statuses combined with the Boolean operator OR within the query. And make sure, as well, that you title your report.
Select Search to generate the report.