Actually, our library never used this feature: OpacSuppression, that is always set as &#39;Don&#39;t hide&#39;. Moreover, we don&#39;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&#39;s why I&#39;m still confused. Does Koha retain those &#39;deleted&#39; items for any further reference, or those are supposed to be &#39;suppressed&#39; items? What the reason could be?<br>
<br><div class="gmail_quote">On Fri, Dec 3, 2010 at 1:30 PM, Fridolyn SOMERS <span dir="ltr">&lt;<a href="mailto:fridolyn.somers@gmail.com">fridolyn.somers@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hie,<br><br>The suppressed (=&quot;deleted&quot;) 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><br>


<br><div class="gmail_quote">2010/12/2 Altaf Mahmud <span dir="ltr">&lt;<a href="mailto:altaf.mahmud@gmail.com" target="_blank">altaf.mahmud@gmail.com</a>&gt;</span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div><div></div><div class="h5">

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><font color="#888888"><br clear="all"><br>-- <br>Altaf Mahmud<br>System Programmer<br>Ayesha Abed Library<br>BRAC University<br>Bangladesh.<br><br>
</font><br></div></div>_______________________________________________<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><br></blockquote></div><br><br clear="all"><br><br>
</blockquote></div><br><br clear="all"><br>-- <br>Altaf Mahmud<br>System Programmer<br>Ayesha Abed Library<br>BRAC University<br>Bangladesh.<br><br>