[Koha] report for items in transit

[vikram zadgaonkar]

Thanks a lot. Its working.

Vikram Zadgaonkar


On Tue, Jun 3, 2014 at 6:04 PM, Katelyn Browne <kbrowne at ccpcs.org> wrote:

> 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
>>
>
>