[Koha] Database entire list

[Lennon Mazonde]

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