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">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;">
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>_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org">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>