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?<br>
<br><div class="gmail_quote">On Fri, Dec 3, 2010 at 1:30 PM, Fridolyn SOMERS <span dir="ltr"><<a href="mailto:fridolyn.somers@gmail.com">fridolyn.somers@gmail.com</a>></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 (="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><br>
<br><div class="gmail_quote">2010/12/2 Altaf Mahmud <span dir="ltr"><<a href="mailto:altaf.mahmud@gmail.com" target="_blank">altaf.mahmud@gmail.com</a>></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>