0
votes

The SOLR search results contain:

The ColdFusion tag has:

<cfsearch 
    collection = "TheCollName" 
    name = "TheSearchName"
    criteria = "custom4_s:4628"

which works fine for ID 4628.

How do I format a search for any of these exact IDs 104,1,129,4649? Using criteria = "custom4_s:(104 1 129 4649)" doesn't find 104,1,129,4649 but does find either 104 or 1 or 129 or 4649. "custom4_s:(*104* *1* *129* *4649*)" returns any ID with a 1.

Is there a

[begin word boundary OR ","]104[end word boundary OR ","]
[begin word boundary OR ","]1[end word boundary OR ","]
[begin word boundary OR ","]129[end word boundary OR ","]
[begin word boundary OR ","]4649[end word boundary OR ","]

? Hoping for one statement that will detect each specific ID by itself and instances where that ID is in a list.

If search data are 104,1,129,4649, the search results will include each string containing any of the tokens. For instance: 104,8,9,4 would be found but not 1044,8,9,4.

The 1 in the data is a brutal in how many false positives it detects using wildcards.