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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha