Hi, A specific SQL report that might be of use is the following (from http://wiki.koha-community.org/wiki/SQL_Reports_Library#List_new_items): List new items * *Developer:*Sharon Moreland * *Module:*Catalog * *Purpose:*List new items * *Status:*Complete SELECT items.dateaccessioned,biblio.title,items.itemcallnumber FROM itemsLEFT JOIN biblioitemsON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblioON (biblioitems.biblionumber=biblio.biblionumber) WHERE DATE(items.dateaccessioned) BETWEEN <<Between(yyyy-mm-dd)|date >> AND <<and(yyyy-mm-dd)|date >> AND items.homebranch=<<Home branch|branches >> ORDER BY items.itemcallnumberASC You can test it out on my demo site to check if it's safe and does what you want: http://staffdemo.muhachabooks.com. Username and password - demo, demo. Lennon Mazonde On 1/25/2016 10:13 AM, Indranil Das Gupta wrote:

Three tables in your db - (a) biblio (b) biblioitems (c) items contain the crucial info.

Koha DB schema - http://schema.koha-community.org

Koha SQL reports library - http://wiki.koha-community.org/wiki/SQL_Reports_Library On Jan 25, 2016 12:09 PM, "Usashi Chatterjee" <usashi.chatterjee@gmail.com> wrote:

...

How can I find the entire list of items that I have entered in my Koha database

-- ........... Thanks & Regards *Usashi Chatterjee* _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha