You are here:
< Back

This report will generate the current list of electronic items with the status «In transit». Then, manually check in each item to change the status to «Available».


1 Go to > Reports

2. Click on « + Create from SQL »

3. Fill in the form

4. Copy the following text:

SELECT
        biblio.title AS "Titre",
        biblio.author AS "Auteur",
        items.barcode AS "Code-barres",
DATE(branchtransfers.datesent) AS "En transit depuis le",
CONCAT('<a href="/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=', biblionumber, '&itemnumber=', itemnumber, '#edititem', '">Voir le document</a>' ) AS ""
FROM
     branchtransfers
     JOIN items USING(itemnumber)
     JOIN biblio USING(biblionumber)
 WHERE
     datearrived IS NULL
AND
     tobranch=<<Bibliothèque|branches>>


5. Paste the text in the « SQL» box.


6. Click on « Save report ».

7. Click on « Run report»


7. Select your « digital library » name and click on «Run report»


A list of items will appear. Copy an item barcode and check in manually the item.

See: Prêt Numérique: «In Transit» item.

Last Updated On March 22, 2021