SOLR searching multiple dynamic field _b boolean fields at the same time

Forum|Forum|4 years ago
April 14, 2021
1 reply
336 views

I am using Coldfusion 2018 cfsearch, which uses SOLR.

When I do a search on a dynamic boolean field like so, it works and returns correct results.

When I try to query more than one dynamic boolean fields:

<CFSEARCH name = "GetResults" collection = "mycollection" criteria="is_ethics_b:1 AND is_visible_b:0"

>

I have tried other combinations but I get variations of the same error:

cannot convert the value "1 AND is_visible_b:0" to a boolean

What is best way to query two dynamic _b fields?

Also, is there a way to test the query directly on the SOLR server?

Thank you for any help.

This topic has been closed for replies.

D

Dave Watts

Community Expert

I don't know if there's a way to search for two boolean values in a Solr search. You could, however, run two CFSEARCH tags then merge the results into a single query object.

I'm blanking on the URL for accessing Solr directly, but you should see submitted Solr queries in the Jetty log files - Jetty is the servlet engine that runs Solr as part of the "add-on services" if I recall correctly.

Dave Watts, Eidolon LLC

C

C5C58Author

Participant

Thank you for your reply. It is strange that I can't search two boolean values.

I ended up changing all my boolean _b to integer _i fields. It appears to work for my purpose so I'll just stick with that.

Thank you again.

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