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

[C5C58]

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.

<CFSEARCH name = "GetResults" collection = "mycollection" criteria="is_ethics_b:1" >

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

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

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

>

<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.

[Dave Watts]

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

[C5C58]

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.