https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38700 Bug ID: 38700 Summary: Add items table field to record transfer status Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: andrew@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org Checking whether or not an item is currently in-transit using SQL is more complicated than one would like. We know an item is currently in-transit if there is a line in branchtransfers with that itemnumber, with a date sent, and without either a date cancelled or a date received. I suggest we add a field to items that would work like items.onloan does for issues. We name the field items.intransit and when the transfer is sent we put something in the field (either the transfer ID or the branch to which the item is headed) and when the transfer is either completed or cancelled we null items.intransit. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.