Comment 3 for bug 1018011

Blake GH (bmagic) wrote :

I found that this query identifies the situation:

select "all",barcode from
(select string_agg(status::text,',' order by audit_id) as "all",barcode from
auditor.asset_copy_history group by barcode)
 as aach
 where "all" ~ '7,1,0'

Finding items that went from re-shelving to checked out to available