<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">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 class=""><br class=""></div><div class="">Actually, since I’ve got a fresh db handy, run this:</div><div class=""><font face="Courier New" class="">select id, field_class, name from config.metabib_field where id between 2 and 6 order by id;</font></div><div class=""><font face="Courier New" class=""> id | field_class | name </font></div><div class=""><font face="Courier New" class="">----+-------------+-------------<br class=""> 2 | title | abbreviated<br class=""> 3 | title | translated<br class=""> 4 | title | alternative<br class=""> 5 | title | uniform<br class=""> 6 | title | proper<br class="">(5 rows)<br class=""></font><br class=""><div class=""><div class="">
<meta charset="UTF-8" class=""><div dir="auto" style="text-align: start; text-indent: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="text-align: start; text-indent: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="text-align: start; text-indent: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><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 class=""></div><div>Jason</div><div><br class="">-- <br class="">Jason Boyer<br class="">Senior System Administrator<br class="">Equinox Open Library Initiative<br class=""><a href="mailto:JBoyer@equinoxOLI.org" class="">JBoyer@equinoxOLI.org</a><br class="">+1 (877) Open-ILS (673-6457)<br class="">https://equinoxOLI.org/</div></div></div></div>
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On May 25, 2022, at 5:33 PM, Josh Stompro via Evergreen-dev <<a href="mailto:evergreen-dev@list.evergreen-ils.org" class="">evergreen-dev@list.evergreen-ils.org</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">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 class=""><br class=""></div><div class="">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 class=""><br class=""></div><div class="">Josh<br class=""><div class=""><br class=""></div><div class=""> </div></div></div><br class=""><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" class="">stomproj@gsuite.larl.org</a>> wrote:<br class=""></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" class="">Michele, thank you very much for pointing that out, that does seem promising. I'll report back after trying the fix.<div class="">Josh</div><div class=""><br class=""></div></div><br class=""><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" class="">mmorgan@noblenet.org</a>> wrote:<br class=""></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" class=""><div class="gmail_default" style="font-family:verdana,sans-serif">Hi Josh,</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br class=""></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 class=""></div><div class="gmail_default" style="font-family:verdana,sans-serif"><a href="https://bugs.launchpad.net/evergreen/+bug/1942467" target="_blank" class="">https://bugs.launchpad.net/evergreen/+bug/1942467</a><br class=""></div><div class="gmail_default" style="font-family:verdana,sans-serif"><br class=""></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 class=""></div><div class="gmail_default" style="font-family:verdana,sans-serif"><br class=""></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 class=""></div><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div class=""><span style="font-family:verdana,sans-serif" class="">--</span><br class=""></div><div class=""><font face="verdana, sans-serif" class="">Michele M. Morgan, <span style="font-size:12.8px" class="">Technical Support Analyst<br class=""></span></font></div><div class=""><span style="font-size:12.8px" class=""><font face="verdana, sans-serif" class="">North of Boston Library Exchange, Danvers Massachusetts</font></span></div><div class=""><span style="font-size:12.8px" class=""><a href="mailto:mmorgan@noblenet.org" target="_blank" class=""><font face="verdana, sans-serif" class="">mmorgan@noblenet.org</font></a></span></div><div class=""><br class=""></div></div></div></div></div></div></div></div><br class=""></div><br class=""><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" class="">evergreen-dev@list.evergreen-ils.org</a>> wrote:<br class=""></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" class="">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 class=""><br class=""></div><div class="">I'm looking at the docs for the virtual index definitions</div><div class=""><a href="https://docs.evergreen-ils.org/3.2/_virtual_index_definitions.html" target="_blank" class="">https://docs.evergreen-ils.org/3.2/_virtual_index_definitions.html</a></div><div class=""><br class=""></div><div class="">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 class=""><br class=""></div><div class="">Even though the record with Hotspot in the title also has "Hotspot" in the 520 field.</div><div class=""><br class=""></div><div class="">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 class=""><br class=""></div><div class="">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 class=""><br class=""></div><div class="">Thanks</div><div class="">Josh</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br clear="all" class=""><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><table style="padding:0px;margin:10px 0px;border:none" class=""><tbody class=""><tr class=""><td style="vertical-align:middle;padding:0px 7px 0px 0px" class=""><img alt="Company logo" height="107" src="https://storage.googleapis.com/signaturesatori/customer-C039u5c5y/images/7DIM6.png" width="125" class=""></td><td style="border-left:3px solid rgb(232,232,232);padding:7px 0px 0px 10px" class="">
<div style="font-family:arial,helvetica,sans-serif;font-size:14px;line-height:17px;font-weight:bold;color:rgb(238,142,22)" class=""><span style="" class=""><strong class="">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;" class="">IT Director<br class="">
<a href="mailto:stomproj@gsuite.larl.org" target="_blank" class=""><span style="color:rgb(27,70,152)" class="">stomproj@gsuite.larl.org</span></a><span style="color:rgb(27,70,152)" class=""> </span>| 218-233-3757 ext. 139<span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:small;color:rgb(32,33,36)" class=""> </span>| 218-790-2110</div>
<div style="font-family: arial, helvetica, sans-serif; font-size: 12px; line-height: 14px;" class=""><strong class="">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;" class="">118 5th ST S<br class="">Moorhead MN 56560<br class="">
<a href="http://www.larl.org/" target="_blank" class=""><span style="color:rgb(27,70,152)" class="">www.larl.org</span></a><br class="">
<em class="">Our mission is to enrich lives and strengthen communities.</em></div>
</td></tr></tbody></table>
</div></div></div></div></div>
_______________________________________________<br class="">
Evergreen-dev mailing list<br class="">
<a href="mailto:Evergreen-dev@list.evergreen-ils.org" target="_blank" class="">Evergreen-dev@list.evergreen-ils.org</a><br class="">
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev" rel="noreferrer" target="_blank" class="">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev</a><br class="">
</blockquote></div>
</blockquote></div>
</blockquote></div>
_______________________________________________<br class="">Evergreen-dev mailing list<br class=""><a href="mailto:Evergreen-dev@list.evergreen-ils.org" class="">Evergreen-dev@list.evergreen-ils.org</a><br class="">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-dev<br class=""></div></blockquote></div><br class=""></div></div></body></html>