[Koha] Which table contains the holding information?

Nicole Engard nengard at gmail.com
Thu Nov 4 16:27:09 NZDT 2010


Altaf,

The info is in a combination of tables.  The issues table holds all
the items that are checked out using the itemnumber (and other
fields).  The items table holds all items so using the itemnumber in
both tables you should be able to gather the info you're looking for.

Nicole

2010/11/4 Altaf Mahmud <altaf.mahmud at gmail.com>:
> Dear all,
>
> I am using Koha 3.2. I want to know which table in Koha database contains
> the holding status (available/unavailable)? I just have taken a look, but
> couldn't point out the table I am looking for. Is it specifically mentioned
> in any table? Or do I've to query multiple tables and calculate the number
> of items that are available? How Koha displays that information? Please give
> me a clue.
>
> Thank you.
>
>
> --
> Altaf Mahmud
> System Programmer
> Ayesha Abed Library
> BRAC University
> Bangladesh.
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>


More information about the Koha mailing list