Thanks, I just learned a lot! On Fri, Dec 3, 2010 at 6:28 PM, Fischer, Katrin <[email protected]>wrote:
> Hi, > > > > suppressed and deleted are different things. > That what I guessed :) > > > 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 > I found this feature under cataloging section of the manual: http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN296 > > > 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. > Couldn't find the file even by exhaustive 'find' command, is it possible to provide the exact path? I need to have those data somehow. > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Altaf Mahmud > *Sent:* Friday, December 03, 2010 12:34 PM > *To:* Fridolyn SOMERS > *Cc:* [email protected]; [email protected] > *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 <[email protected]> > 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 > [email protected] > > 2010/12/2 Altaf Mahmud <[email protected]> > > 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 > [email protected] > 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. > -- Altaf Mahmud System Programmer Ayesha Abed Library BRAC University Bangladesh.
_______________________________________________ Koha-devel mailing list [email protected] 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/
