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" <[email protected]>
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
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
