<div class="gmail_quote">To query into the XML (marcxml field), you can use a MySQL 5.1 feature that includes an XPATH into SQL : <br>
<a href="http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html">http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html</a><br>
<br>
Reards<br><br>2010/12/3 Fischer, Katrin <span dir="ltr"><<a href="mailto:Katrin.Fischer@bsz-bw.de">Katrin.Fischer@bsz-bw.de</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 link="blue" vlink="purple" lang="DE">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Hi, </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">it’s not a file, but in the database. The table is called
bibliotitems and the field is marcxml. </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">But it’s the whole MARC21 record in XML syntax and not only the
field for OPAC suppression. </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">So you have to parse it for the field you want to check. </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Hope that helps, </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Katrin</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color blue; padding: 0cm 0cm 0cm 4pt;">
<div>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> Altaf Mahmud
[mailto:<a href="mailto:altaf.mahmud@gmail.com" target="_blank">altaf.mahmud@gmail.com</a>] <br>
<b>Sent:</b> Friday, December 03, 2010 3:14 PM<br>
<b>To:</b> Fischer, Katrin<div><div></div><div class="h5"><br>
<b>Cc:</b> <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a>; <a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<b>Subject:</b> Re: [Koha-devel] Suppressing records in Koha 3.2.x</div></div></span></p>
</div>
</div><div><div></div><div class="h5">
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">Please ignore this if found
repetitive. I got a bounced reply for the last one.<br>
<br>
<br>
Thanks, I just learned a lot!</p>
<div>
<p class="MsoNormal">On Fri, Dec 3, 2010 at 6:28 PM, Fischer, Katrin <<a href="mailto:Katrin.Fischer@bsz-bw.de" target="_blank">Katrin.Fischer@bsz-bw.de</a>> wrote:</p>
<div>
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Hi, </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">suppressed and deleted are
different things.</span></p>
</div>
</div>
<div>
<p class="MsoNormal"><br>
That what I guessed :) </p>
</div>
<blockquote style="border-width: medium medium medium 1pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color rgb(204, 204, 204); padding: 0cm 0cm 0cm 6pt; margin-left: 4.8pt; margin-right: 0cm;">
<div>
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Deleted things go into the
tables mentioned before.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">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.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">The feature is described in
the Koha manual: <a href="http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN3113" target="_blank">http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN3113</a></span></p>
</div>
</div>
</blockquote>
<div>
<p class="MsoNormal"><br>
Though I found this feature under cataloging section of the manual: <a href="http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN296" target="_blank">http://koha-community.org/documentation/3-2-manual/index.php?ch=c18#AEN296</a>
</p>
</div>
<blockquote style="border-width: medium medium medium 1pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color rgb(204, 204, 204); padding: 0cm 0cm 0cm 6pt; margin-left: 4.8pt; margin-right: 0cm;">
<div>
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">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.</span></p>
</div>
</div>
</blockquote>
<div>
<p class="MsoNormal"><br>
Couldn't find the file even by exhaustive 'find' command, is it possible to
provide the exact path? I need to have those data somehow. </p>
</div>
<blockquote style="border-width: medium medium medium 1pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color rgb(204, 204, 204); padding: 0cm 0cm 0cm 6pt; margin-left: 4.8pt; margin-right: 0cm;">
<div>
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<div style="border-width: medium medium medium 1.5pt; border-style: none none none solid; padding: 0cm 0cm 0cm 4pt; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color blue;">
<div>
<div style="border-width: 1pt medium medium; border-style: solid none none; padding: 3pt 0cm 0cm; border-color: -moz-use-text-color;">
<p class="MsoNormal"><b><span style="font-size: 10pt;" lang="EN-US">From:</span></b><span style="font-size: 10pt;" lang="EN-US"> <a href="mailto:koha-devel-bounces@lists.koha-community.org" target="_blank">koha-devel-bounces@lists.koha-community.org</a>
[mailto:<a href="mailto:koha-devel-bounces@lists.koha-community.org" target="_blank">koha-devel-bounces@lists.koha-community.org</a>] <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> <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a>;
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<b>Subject:</b> Re: [Koha-devel] Suppressing records in Koha 3.2.x</span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal" style="margin-bottom: 12pt;">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?</p>
<div>
<p class="MsoNormal">On
Fri, Dec 3, 2010 at 1:30 PM, Fridolyn SOMERS <<a href="mailto:fridolyn.somers@gmail.com" target="_blank">fridolyn.somers@gmail.com</a>>
wrote:</p>
<p class="MsoNormal" style="margin-bottom: 12pt;">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></p>
<div>
<p class="MsoNormal">2010/12/2
Altaf Mahmud <<a href="mailto:altaf.mahmud@gmail.com" target="_blank">altaf.mahmud@gmail.com</a>></p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;">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: rgb(136, 136, 136);"><br clear="all">
<br>
-- <br>
Altaf Mahmud<br>
System Programmer<br>
Ayesha Abed Library<br>
BRAC University<br>
Bangladesh.</span></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></p>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
<br clear="all">
</p>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
<br clear="all">
<br>
-- <br>
Altaf Mahmud<br>
System Programmer<br>
Ayesha Abed Library<br>
BRAC University<br>
Bangladesh.</p>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
<br clear="all">
<br>
-- <br>
Altaf Mahmud<br>
System Programmer<br>
Ayesha Abed Library<br>
BRAC University<br>
Bangladesh.</p>
</div></div></div>
</div>
</div>
<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>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>