[Koha] report for items in transit

[Katelyn Browne]

We don't really use "in transit," but I think this should do what you want:

SELECT bt.itemnumber, b.title, i.itemcallnumber, i.barcode, bt.datesent,
bt.frombranch, bt.tobranch
FROM branchtransfers bt
LEFT JOIN items i USING (itemnumber)
LEFT JOIN biblio b USING (biblionumber)
WHERE bt.datearrived IS NULL

Katelyn Browne
Middle/High School Librarian
Capital City Public Charter School
100 Peabody Street NW
Washington, DC 20011
(202) 387-0309 x1745
kbrowne at ccpcs.org
http://www.ccpcs.org/library/


On Tue, Jun 3, 2014 at 5:59 AM, vikram zadgaonkar <
vikramczadgaonkar at gmail.com> wrote:

> Hi,
> I am looking for a report for all items which are in transit.
> Thanks in advance.
> Vikram Zadgaonkar
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>