<html><body><body bgcolor="#FFFFFF" text="#000000"><div>Hi David,<br/><br/>Nice! Would that also work for our problem with empty facets by any chance?<br/><br/>Cheers,<br/><br/>Mirko<br/><br/><br/>David Cook schrieb:</div><blockquote cite="mid:002401d120d0$f8135d00$e83a1700$@prosentient.com.au" type="cite"><style>
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;;}
a:link, span.MsoHyperlink
color:#0563C1;
text-decoration:underline;;}
a:visited, span.MsoHyperlinkFollowed
color:#954F72;
text-decoration:underline;;}
pre
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";;}
span.EmailStyle17
font-family:"Calibri",sans-serif;
color:windowtext;;}
span.HTMLPreformattedChar
font-family:"Courier New";;}
.MsoChpDefault
font-family:"Calibri",sans-serif;;}
div.WordSection1
;}</style><div class="WordSection1"><p class="MsoNormal">Hey all:</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">I just opened Bug 15198 (<a ext-href="http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15198" class="moz-external-link">http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15198</a>) which contains some instructions for how to make it so that you can turn on OpacSuppression and still retrieve search results, even if you don’t have any suppressed records (942$n = 1) in Zebra.</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">I ramble about it below but everything you actually need to know is in the bug report.</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">I would supply a patch myself, but I’m having issues building Perl dependencies for Master, so I won’t be contributing any patches until I get that sorted…</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Cheers,</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">-David</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">--</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal"></p><p> </p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">So I was reading the Zebra docs again (as you do), and I noticed a special attribute type of 14 which could help out with our OpacSuppression issue (whereby you get 0 results – well actually a 114 error – if you don’t have any records suppressed but are sending queries checking for suppression).</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Observe:</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Z> find @attr 14=1 @not @attr 1=4 test @attr 1=9011 1</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Sent searchRequest.</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Received SearchResponse.</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Search was a success.</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Number of hits: 8, setno 20</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">SearchResult-1: term=test cnt=8, term=1 cnt=0</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">records returned: 0</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Elapsed: 0.000678</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Z> find @not @attr 1=4 test @attr 1=9011 1</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Sent searchRequest.</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Received SearchResponse.</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Search was a bloomin' failure.</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Number of hits: 0, setno 21</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Result Set Status: none</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">records returned: 0</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Diagnostic message(s) from database:</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;"> [114] Unsupported Use attribute -- v2 addinfo '9011'</span></p><p></p><p class="MsoNormal" style=""><span style="font-size:10.0pt;;font-family:";color:black;">Elapsed: 0.000650</span></p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Here’s the info about attribute type 14 from the Zebra docs (http://www.indexdata.com/zebra/doc/querymodel-zebra.html):</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Specifies whether un-indexed fields should be ignored. A zero value (default) throws a diagnostic when an un-indexed field is specified. A non-zero value makes it return 0 hits.</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Cheers to Jesse Weaver for realizing the syntax was @attr 14=1.</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">For those of you who don’t read PQF, I’ll do it in CCL too:</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Z> find ignore-empty=(kw=test not Suppress=1)</p><p></p><p class="MsoNormal">Sent searchRequest.</p><p></p><p class="MsoNormal">Received SearchResponse.</p><p></p><p class="MsoNormal">Search was a success.</p><p></p><p class="MsoNormal">Number of hits: 97, setno 2</p><p></p><p class="MsoNormal">SearchResult-1: term=test cnt=97, term=1 cnt=0</p><p></p><p class="MsoNormal">records returned: 0</p><p></p><p class="MsoNormal">Elapsed: 0.000969</p><p></p><p class="MsoNormal">Z> find kw=test not Suppress=1</p><p></p><p class="MsoNormal">Sent searchRequest.</p><p></p><p class="MsoNormal">Received SearchResponse.</p><p></p><p class="MsoNormal">Search was a bloomin' failure.</p><p></p><p class="MsoNormal">Number of hits: 0, setno 3</p><p></p><p class="MsoNormal">Result Set Status: none</p><p></p><p class="MsoNormal">records returned: 0</p><p></p><p class="MsoNormal">Diagnostic message(s) from database:</p><p></p><p class="MsoNormal"> [114] Unsupported Use attribute -- v2 addinfo '9011'</p><p></p><p class="MsoNormal">Elapsed: 0.000841</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">*Note that I just added “ignore-empty 14=1” to my ccl.properties to get that ignore-empty=() to work.</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Actually, the lightest touch for this issue would be to change:</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Suppress 1=9011</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">To</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Suppress 1=9011 14=1</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Check that out:</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal">Z> find kw=test not Suppress=1</p><p></p><p class="MsoNormal">Sent searchRequest.</p><p></p><p class="MsoNormal">Received SearchResponse.</p><p></p><p class="MsoNormal">Search was a success.</p><p></p><p class="MsoNormal">Number of hits: 97, setno 1</p><p></p><p class="MsoNormal">SearchResult-1: term=test cnt=97, term=1 cnt=0</p><p></p><p class="MsoNormal">records returned: 0</p><p></p><p class="MsoNormal">Elapsed: 0.005849</p><p></p><p class="MsoNormal"></p><p> </p><p class="MsoNormal"></p><p> </p><p class="MsoNormal"></p><p> </p><p class="MsoNormal"><span style="">David Cook</span></p><p></p><p class="MsoNormal"><span style="">Systems Librarian</span></p><p></p><p class="MsoNormal"><span style="">Prosentient Systems</span></p><p></p><p class="MsoNormal"><span style="">72/330 Wattle St, Ultimo, NSW 2007</span></p><p></p><p class="MsoNormal"></p><p> </p></div></blockquote><div></div>
</body></html>