The deletedbiblio, deletedbiblioitems and deleteditems tables are for materials that have been deleted from your catalog. This provides a failsafe recovery option, in case the deletion was not correct. If you're confident you don't need any of the materials in those tables, you can truncate them to clear up space. It's much like emptying the trash on many desktop systems.<br>
<div class="gmail_quote">
<br>OpacSuppression is determined by the 942$n MARC subfield. It is not mapped to the database, so you'll need to query and parse the MARC record in order to get a list of all items that are suppressed from OPAC view. <br>
<br><br>-Ian<br><br><br><br><div class="gmail_quote">2010/12/3 Altaf Mahmud <span dir="ltr"><<a href="mailto:altaf.mahmud@gmail.com" target="_blank">altaf.mahmud@gmail.com</a>></span><div><div></div><div class="h5">
<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
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?<div>
<div></div><div><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" target="_blank">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>
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>
</div></div><br>_______________________________________________<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></div></div><font color="#888888"><br><br clear="all"><br>-- <br>Ian Walls<br>Lead Development Specialist<br>
ByWater Solutions<br>Phone # (888) 900-8944<br>
<a href="http://bywatersolutions.com" target="_blank">http://bywatersolutions.com</a><br><a href="mailto:ian.walls@bywatersolutions.com" target="_blank">ian.walls@bywatersolutions.com</a><br>Twitter: @sekjal<br>
</font></div><br><br clear="all"><br>-- <br>Ian Walls<br>Lead Development Specialist<br>ByWater Solutions<br>Phone # (888) 900-8944<br><a href="http://bywatersolutions.com">http://bywatersolutions.com</a><br><a href="mailto:ian.walls@bywatersolutions.com">ian.walls@bywatersolutions.com</a><br>
Twitter: @sekjal<br>