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.
Copy link to clipboard
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
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.