The deletedbiblio, deletedbiblioitems and deleteditems tables are for materials that have been deleted from your catalog. This provides a failsafe recovery option, in case the deletion was not correct. If you're confident you don't need any of the materials in those tables, you can truncate them to clear up space. It's much like emptying the trash on many desktop systems. OpacSuppression is determined by the 942$n MARC subfield. It is not mapped to the database, so you'll need to query and parse the MARC record in order to get a list of all items that are suppressed from OPAC view. -Ian 2010/12/3 Altaf Mahmud <altaf.mahmud@gmail.com> Actually, our library never used this feature: OpacSuppression, that is

always set as 'Don't hide'. Moreover, we don't have any marc record with $942 field, but the *deletedbiblio, deletedbiblioitems *and *deleteditems *still have data. After getting your mail, I searched some items in normal OPAC view which are in *deletedbiblio *table. I got the items in Koha, the records are also in *biblio* table. That's why I'm still confused. Does Koha retain those 'deleted' items for any further reference, or those are supposed to be 'suppressed' items? What the reason could be?

On Fri, Dec 3, 2010 at 1:30 PM, Fridolyn SOMERS <fridolyn.somers@gmail.com

...

wrote:

...

Hie,

The suppressed (="deleted") records from tables *biblio, biblioitems* and *items* are moved when deleted into tables *deletedbiblio*, * deletedbiblioitems* and *deleteditems*.

Some other tables have a corresponding table beginning with *deleted* or *old*.

Regards,

-- Fridolyn SOMERS ICT engineer PROGILONE - Lyon - France fridolyn.somers@gmail.com

2010/12/2 Altaf Mahmud <altaf.mahmud@gmail.com>

...

Hello,

Can someone please tell me how can I query to list the suppressed items in Koha database? Which database field indicates that the item is suppressed in OPAC view?

Thanks.

-- Altaf Mahmud System Programmer Ayesha Abed Library BRAC University Bangladesh.

_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/

-- Altaf Mahmud System Programmer Ayesha Abed Library BRAC University Bangladesh.

_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/

-- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal -- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com ian.walls@bywatersolutions.com Twitter: @sekjal