<div dir="ltr">Thank you Jason, I checked and our DB matches what your query returns.<div><br></div><div>I made a few adjustments, and now I am getting better results. I had the Physical Properties virtual index set to -1 weight to try an fix some other strange result, but I'm thinking that may have been what was down ranking these records, since the record in question has the word "hotspot" in the physical description. I'm planning on putting things back and see if I can replicate it.</div><div><br></div><div>I think I probably was just running into the search cache. Michele's ticket helpfully used the catch killer string in examples.</div><div><br></div><div>Josh</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 26, 2022 at 5:51 AM Jason Boyer <<a href="mailto:JBoyer@equinoxoli.org">JBoyer@equinoxoli.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="overflow-wrap: break-word;">Something I would suggest looking at is a comparison of your config.metabib_field table and what’s built in stock. Depending on the age and upgrade path for a database it may not have one of the title fields in the expected place or at all (id 4 or 5, I don’t remember which off hand) and all of the subsequent rows have their ids offset by 1. Since there have been upgrade scripts after that time that referenced cmd fields > 3 by id I’ve seen systems get strange results if they’re affected. I’ve got some SQL somewhere that can be adapted to fix it if needed. Usually after fixing this you can reset all of the weights to stock and get good results.<div><br></div><div>Actually, since I’ve got a fresh db handy, run this:</div><div><font face="Courier New">select id, field_class, name from config.metabib_field where id between 2 and 6 order by id;</font></div><div><font face="Courier New"> id | field_class | name </font></div><div><font face="Courier New">----+-------------+-------------<br> 2 | title | abbreviated<br> 3 | title | translated<br> 4 | title | alternative<br> 5 | title | uniform<br> 6 | title | proper<br>(5 rows)<br></font><br><div><div>
<div dir="auto" style="text-align:start;text-indent:0px"><div dir="auto" style="text-align:start;text-indent:0px"><div dir="auto" style="text-align:start;text-indent:0px"><div>If you don’t get the results above there’s nothing you can do by adjusting relevancy rankings that will fix it.</div><div><br></div><div>Jason</div><div><br>-- <br>Jason Boyer<br>Senior System Administrator<br>Equinox Open Library Initiative<br><a href="mailto:JBoyer@equinoxOLI.org" target="_blank">JBoyer@equinoxOLI.org</a><br>+1 (877) Open-ILS (673-6457)<br><a href="https://equinoxOLI.org/" target="_blank">https://equinoxOLI.org/</a></div></div></div></div>
</div>
<div><br><blockquote type="cite"><div>On May 25, 2022, at 5:33 PM, Josh Stompro via Evergreen-dev <<a href="mailto:evergreen-dev@list.evergreen-ils.org" target="_blank">evergreen-dev@list.evergreen-ils.org</a>> wrote:</div><br><div><div dir="ltr">Michele, I think my weights are already different, so I don't think I'm running into this. The search is coming up with the correct results, it just seems like the relevance ranking should be placing the title first, or close to first since the keyword is in the title.<div><br></div><div>I'll keep poking at it, maybe I was just running into search cache issues. I restarted the open-ils.search, but didn't use the cache buster string when I was testing.</div><div><br></div><div>Josh<br><div><br></div><div> </div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, May 25, 2022 at 3:55 PM Josh Stompro <<a href="mailto:stomproj@gsuite.larl.org" target="_blank">stomproj@gsuite.larl.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Michele, thank you very much for pointing that out, that does seem promising. I'll report back after trying the fix.<div>Josh</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, May 25, 2022 at 3:37 PM Morgan, Michele <<a href="mailto:mmorgan@noblenet.org" target="_blank">mmorgan@noblenet.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif">Hi Josh,</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif">Have you seen this Launchpad bug?</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif"><a href="https://bugs.launchpad.net/evergreen/+bug/1942467" target="_blank">https://bugs.launchpad.net/evergreen/+bug/1942467</a><br></div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif">I'm not sure if it's related, but the term "performing strangely" in your description made me think of it.<br></div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif">Just a thought,</div><div class="gmail_default" style="font-family:verdana,sans-serif">Michele</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><span style="font-family:verdana,sans-serif">--</span><br></div><div><font face="verdana, sans-serif">Michele M. Morgan, <span style="font-size:12.8px">Technical Support Analyst<br></span></font></div><div><span style="font-size:12.8px"><font face="verdana, sans-serif">North of Boston Library Exchange, Danvers Massachusetts</font></span></div><div><span style="font-size:12.8px"><a href="mailto:mmorgan@noblenet.org" target="_blank"><font face="verdana, sans-serif">mmorgan@noblenet.org</font></a></span></div><div><br></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, May 25, 2022 at 4:21 PM Josh Stompro via Evergreen-dev <<a href="mailto:evergreen-dev@list.evergreen-ils.org" target="_blank">evergreen-dev@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hello, does anyone know of a guide or have any tips on figuring out why a relevancy ranked keyword search seems to be performing strangely?<div><br></div><div>I'm looking at the docs for the virtual index definitions</div><div><a href="https://docs.evergreen-ils.org/3.2/_virtual_index_definitions.html" target="_blank">https://docs.evergreen-ils.org/3.2/_virtual_index_definitions.html</a></div><div><br></div><div>I went into the "All Searchable Fields" entry, and used the manage link to see the virtual fields. And I see that I cranked up the weight for the "Main Title" a few years ago. But a keyword search for "Hotspot" is showing titles with "Hotspot" in the 520 field before those that have it in the title.</div><div><br></div><div>Even though the record with Hotspot in the title also has "Hotspot" in the 520 field.</div><div><br></div><div>If there is a way to see the search details on how the relevancy ranking is calculated, maybe I can spot where I'm going wrong.</div><div><br></div><div>I'm wondering if I'm missing a step where I'm supposed to disable the non virtual metabib fields for the keyword class as search fields, or something like that?</div><div><br></div><div>Thanks</div><div>Josh</div><div><br></div><div><br></div><div><br clear="all"><div><div dir="ltr"><div dir="ltr"><table style="padding:0px;margin:10px 0px;border:none"><tbody><tr><td style="vertical-align:middle;padding:0px 7px 0px 0px"><img alt="Company logo" height="107" src="https://storage.googleapis.com/signaturesatori/customer-C039u5c5y/images/7DIM6.png" width="125"></td><td style="border-left:3px solid rgb(232,232,232);padding:7px 0px 0px 10px">
<div style="font-family:arial,helvetica,sans-serif;font-size:14px;line-height:17px;font-weight:bold;color:rgb(238,142,22)"><span><strong>Josh Stompro</strong></span></div>
<div style="font-family:arial,helvetica,sans-serif;font-size:12px;line-height:14px;font-weight:normal;margin-bottom:10px">IT Director<br>
<a href="mailto:stomproj@gsuite.larl.org" target="_blank"><span style="color:rgb(27,70,152)">stomproj@gsuite.larl.org</span></a><span style="color:rgb(27,70,152)"> </span>| 218-233-3757 ext. 139<span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:small;color:rgb(32,33,36)"> </span>| 218-790-2110</div>
<div style="font-family:arial,helvetica,sans-serif;font-size:12px;line-height:14px"><strong>Lake Agassiz Regional Library </strong></div>
<div style="font-family:arial,helvetica,sans-serif;font-size:12px;line-height:14px;font-weight:normal;margin-bottom:10px">118 5th ST S<br>Moorhead MN 56560<br>
<a href="http://www.larl.org/" target="_blank"><span style="color:rgb(27,70,152)">www.larl.org</span></a><br>
<em>Our mission is to enrich lives and strengthen communities.</em></div>
</td></tr></tbody></table>
</div></div></div></div></div>
_______________________________________________<br>
Evergreen-dev mailing list<br>
<a href="mailto:Evergreen-dev@list.evergreen-ils.org" target="_blank">Evergreen-dev@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev</a><br>
</blockquote></div>
</blockquote></div>
</blockquote></div>
_______________________________________________<br>Evergreen-dev mailing list<br><a href="mailto:Evergreen-dev@list.evergreen-ils.org" target="_blank">Evergreen-dev@list.evergreen-ils.org</a><br><a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev</a><br></div></blockquote></div><br></div></div></div></blockquote></div>