<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=DE link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi, <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>suppressed and deleted are different things.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Deleted things go into the tables mentioned before.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The feature is described in the Koha manual: <a
href="http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN3113">http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN3113</a><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Katrin<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> koha-devel-bounces@lists.koha-community.org
[mailto:koha-devel-bounces@lists.koha-community.org] <b>On Behalf Of </b>Altaf
Mahmud<br>
<b>Sent:</b> Friday, December 03, 2010 12:34 PM<br>
<b>To:</b> Fridolyn SOMERS<br>
<b>Cc:</b> koha@lists.katipo.co.nz; Koha-devel@lists.koha-community.org<br>
<b>Subject:</b> Re: [Koha-devel] Suppressing records in Koha 3.2.x<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>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 <i>deletedbiblio,
deletedbiblioitems </i>and <i>deleteditems </i>still have data. After getting
your mail, I searched some items in normal OPAC view which are in <i>deletedbiblio
</i>table. I got the items in Koha, the records are also in <i>biblio</i>
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?<o:p></o:p></p>
<div>
<p class=MsoNormal>On Fri, Dec 3, 2010 at 1:30 PM, Fridolyn SOMERS <<a
href="mailto:fridolyn.somers@gmail.com">fridolyn.somers@gmail.com</a>>
wrote:<o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Hie,<br>
<br>
The suppressed (="deleted") records from tables <i>biblio,
biblioitems</i> and <i>items</i> are moved when deleted into tables <i>deletedbiblio</i>,
<i>deletedbiblioitems</i> and <i>deleteditems</i>.<br>
<br>
Some other tables have a corresponding table beginning with <i>deleted</i> or <i>old</i>.<br>
<br>
Regards,<br>
<br>
-- <br>
Fridolyn SOMERS<br>
ICT engineer<br>
PROGILONE - Lyon - France<br>
<a href="mailto:fridolyn.somers@gmail.com" target="_blank">fridolyn.somers@gmail.com</a><o:p></o:p></p>
<div>
<p class=MsoNormal>2010/12/2 Altaf Mahmud <<a
href="mailto:altaf.mahmud@gmail.com" target="_blank">altaf.mahmud@gmail.com</a>><o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>Hello,<br>
<br>
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?<br>
<br>
Thanks.<br>
<span style='color:#888888'><br clear=all>
<br>
-- <br>
Altaf Mahmud<br>
System Programmer<br>
Ayesha Abed Library<br>
BRAC University<br>
Bangladesh.<br>
<br>
</span><o:p></o:p></p>
</div>
</div>
<p class=MsoNormal>_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel"
target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a><o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
<br clear=all>
<o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
<br clear=all>
<br>
-- <br>
Altaf Mahmud<br>
System Programmer<br>
Ayesha Abed Library<br>
BRAC University<br>
Bangladesh.<o:p></o:p></p>
</div>
</div>
</body>
</html>