Hi,

suppressed and deleted are different things.

Deleted things go into the tables mentioned before.

Suppressed titles are not shown in OPAC, but can still be researched and displayed in Intranet. It is a separate feature. If you have set the sys pref to don’t hide, you probably have no suppressed records yet. For a record to be suppressed in OPAC view the 942$n field has to be set to 1.

The feature is described in the Koha manual: http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN3113

There is no separate database field where you can see if a title is suppressed. The information is stored in the XML of biblioitems.marcxml.

Katrin

From: koha-devel-bounces@lists.koha-community.org [mailto:koha-devel-bounces@lists.koha-community.org] On Behalf Of Altaf Mahmud
Sent: Friday, December 03, 2010 12:34 PM
To: Fridolyn SOMERS
Cc: koha@lists.katipo.co.nz; Koha-devel@lists.koha-community.org
Subject: Re: [Koha-devel] Suppressing records in Koha 3.2.x

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.