[Evergreen-general] Claims Returns item

[O'Connor, Samantha]

I'm wondering if anyone can help me with something. I am trying to create a report of non-deleted items that have a current claims returned. The templates I have worked with so far are all failing when I try to add the deleted=f filter. Additionally, when I put together queries in the database looking for this information, I get items that were claimed returned at some point in the past but have since been located and checked out by others. I'm filtering both the queries and reports using fine stop reason is claims returned. Is there another way that items that have been claimed returned might show up in the database? Or any suggestions on how to filter my results to only the materials that are currently still checked out to the people who claim to have returned them?

Any help or suggestions would be welcome. Thanks in advance!


Samantha O’Connor

NC Cardinal Training Specialist

NC Dept. of Natural and Cultural Resources

samantha.oconnor at ncdcr.gov<mailto:samantha.oconnor at ncdcr.gov>

https://statelibrary.ncdcr.gov/ld/nc-cardinal

109 East Jones Street | 4640 Mail Service Center
Raleigh, North Carolina 27699-4600

Facebook<https://www.facebook.com/StateLibraryNC/>  Twitter<https://twitter.com/StateLibraryNC>  Instagram<http://www.instagram.com/ncculture>  YouTube<https://www.youtube.com/user/statelibrarync/>  Website<https://statelibrary.ncdcr.gov/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20230525/5cd55444/attachment-0001.htm>