Solr Parser in CF 2023 Question

Question

Does anyone know if CF 2023 uses Solr’s default Query Parser is also known as the “lucene” parser?

I have been testing searches using the term modifiers suggested in the Solr Reference Guide 8.2.

A simple one word keyword search seems to function properly. However, i am getting results with more complex keyword strings that are out of whack.

For example, If I do a search using "medical device" including the quotes as indicated by the guide, the result is 55868 candidate hits. That is roughly 500 hits short of every caniddate in the system! Using our production machine running verity against the same data the actual result should be 1618 candidate hits.

Another example, using "medical device"~4 again results in 55868 candidate hits. The verity equivalent medical<near/4>device is actually 8649. Just for the heck of it, I tried "medical device"~4 without the quotes on the development machine and get 16698 hits. Again, nowhere near the correct number of 8649.

Should I be using different parsing terms for Solr running under CF 2023?

Please advise. Thanks.

AlexCraig · Accepted Answer

Hey Charlie,To begin with the Solr Admin tool which enabled me to query our "Resumes" collection was very helpful.It produced accurate results in every test instance. Thus, it appears our collection is "good". It took awhile, but I believe I have uncovered the source of the problem.Once again, it would appear that using "hidden" Input Types are creating a problem. I used an output tag as indicated in the code below in the page that starts the search and also in the page that does the Solar search AND displays the results at the conclusion of the search (see the code between the asterisks below). The keyword criteria at the start of the search was precisely what I input on the web page. However, if I used the double quote symbol which is required by Solr. The output for the keyword criteria was blank and the search returned whacked results.It appears that using the "hidden" Input Type automatically inserts the double quotes around the entire string. Because just entering a single keyword without double quotes would produce an accurate result and the output tag would accurately display the keyword used at the conclusion of the search.***************************************** Key Words: #Form.keywords# *****************************************The other 24 "hidden" form values appear to work as they should. As long as I do not use a keyword entry, searches produce accurate results as they only involve db queries. So .... can someone please suggest another method of passing keyword strings through a variable in a form in the background to use in a Solr collection search, please? Thanks!Well, my theory about the double quotes being automatically applied in the form code appears to be correct.I solved it by stripping the double quotes out of the field before repopulating the field with solr style keyword strings to include the required double quotes on each side of each keyword element.Thus, for example, instead of ""medical device" AND "orthopedic"", the system was processing "medical device" AND "orthopedic" and it started producing results that mirrored those on the production machine. There is one remaining wrinkle. The results were correct as long as I chose a search that limited it to database defined Job Types. When I had it process ALL candidates in the database, the results were still far greater than they should have be. But that problem is another matter which I'll need to tackle next.I suppose it is all about "eating the elephant one bite at a time"! 😉************************************* Key Words: #Form.keywords#

Dave Watts · Answer

Solr is a superset of Lucene, basically just a web application that works with Lucene. So, my guess is that you're using the Lucene query parser.

You can add query="debug" to find out more information. Your query should have worked the way you wrote it, though. Here's Adobe's guide to Solr queries in CF:

https://helpx.adobe.com/coldfusion/developing-applications/accessing-and-using-data/solr-search-support/solr-search-examples.html

Dave Watts, Eidolon LLC

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded