Skip to main content
AlexCraig
Inspiring
February 19, 2024
Answered

Solr Query Inside CF 2023 Appears to Give Incorrect Results

  • February 19, 2024
  • 1 reply
  • 279 views

OK.

I do a search against my Resumes collection in CF 2023 with the Solr Admin tool using the criteria "medical device" & I get 1325 hits which mirrors what I get from our CF 4.51 producton server..

 

I do a search inside CF 2023 using the below code & I get 15,574 hits.  This approximately mirrors the number of hits I get on the production side if I do a search for either of the terms medical or device. Edit#1:  It occured to me to do a search inside CF 2023 using the  criteria string "medical" OR "device" and I got precisely 15,574 hits, the same as "medical device"!!  Hmmm ....

So what am I doing wrong?

************************

<CFSEARCH NAME="applicants_#var#"
COLLECTION="Resumes"
TYPE="standard"
CRITERIA="medical device" >

*************************

This topic has been closed for replies.
Correct answer AlexCraig

Edit 1:  Well, I spoke too soon.  While the CFSEARCH function is now working properly using combinations of  SOME keywords & phrases, it is still giving bogus results on combinations of keywords & phrases when entering DIFFERENT keywords &/'or DIFFERENT phrases.

The solr admin query tool always give the same results as our production server.

But the CFSEARCH function is still not working properly.  Go figure!

*****************************************

It took more hours over the course of more days than I like to admit.  Sing Hossanah!!  I finally solved the problem.

With verity we used the following CFSEARCH code on collections.  I.E., there were 2 types of searches available in Verity: "SIMPLE" & "EXPLICIT"

********************************

<CFSEARCH NAME="applicants_#var#"

                                COLLECTION="#verityCollection#_Apps_#var#"

                                TYPE="#Form.verityType#"

                                CRITERIA="#Form.keywords#" >

**************************************

The search started working (to a degree)  when I changed it to”

**************************************

<CFSEARCH NAME="applicants_#var#"

                                COLLECTION="Resumes"

                                TYPE="standard"

                                CRITERIA="#Form.keywords#" >

***************************************

I had changed TYPE to “standard” because that is the default Type for Solr.  I FINALLY noticed that TYPE was not used in the CFSEARCH examples I saw listed for Solr even though TYPE was an optional parameter for Solr searches.

***************************************

When I commented out the TYPE line of code as shown below, VIOLA, the searches now mirror the searches on the production machine running using Verity!!!!

***************************************

<CFSEARCH NAME="applicants_#var#"

                                COLLECTION="Resumes"

                                <!---TYPE="standard"                    --->

                                CRITERIA="#Form.keywords#" >

***************************************

For whatever reason, entering the TYPE parameter was porking some of the searches.

 

1 reply

AlexCraig
AlexCraigAuthorCorrect answer
Inspiring
February 20, 2024

Edit 1:  Well, I spoke too soon.  While the CFSEARCH function is now working properly using combinations of  SOME keywords & phrases, it is still giving bogus results on combinations of keywords & phrases when entering DIFFERENT keywords &/'or DIFFERENT phrases.

The solr admin query tool always give the same results as our production server.

But the CFSEARCH function is still not working properly.  Go figure!

*****************************************

It took more hours over the course of more days than I like to admit.  Sing Hossanah!!  I finally solved the problem.

With verity we used the following CFSEARCH code on collections.  I.E., there were 2 types of searches available in Verity: "SIMPLE" & "EXPLICIT"

********************************

<CFSEARCH NAME="applicants_#var#"

                                COLLECTION="#verityCollection#_Apps_#var#"

                                TYPE="#Form.verityType#"

                                CRITERIA="#Form.keywords#" >

**************************************

The search started working (to a degree)  when I changed it to”

**************************************

<CFSEARCH NAME="applicants_#var#"

                                COLLECTION="Resumes"

                                TYPE="standard"

                                CRITERIA="#Form.keywords#" >

***************************************

I had changed TYPE to “standard” because that is the default Type for Solr.  I FINALLY noticed that TYPE was not used in the CFSEARCH examples I saw listed for Solr even though TYPE was an optional parameter for Solr searches.

***************************************

When I commented out the TYPE line of code as shown below, VIOLA, the searches now mirror the searches on the production machine running using Verity!!!!

***************************************

<CFSEARCH NAME="applicants_#var#"

                                COLLECTION="Resumes"

                                <!---TYPE="standard"                    --->

                                CRITERIA="#Form.keywords#" >

***************************************

For whatever reason, entering the TYPE parameter was porking some of the searches.

 

Alex Craig, General Manager&quot;Avid Saltwater Fly Fisherman&quot;