Open ended Numeric range query FTS

Full Text Search
1

Hi,
How to write FTS query for the below:
A < 100 and B > 10

Thanks
Nitesh

2

You may write a conjunct query with two numeric range clauses in it.
While specifying the numeric range clause, you may omit the min and max values on each of the queries.
refer -
https://docs.couchbase.com/server/current/fts/fts-query-types.html#conjunction-query-and
https://docs.couchbase.com/server/current/fts/fts-query-types.html#numeric-range

roughly

{
 "conjuncts":[
   {"field":"A", "max": 100, "inclusive_max": false},
   {"field":"B", "min": 10, "inclusive_min": false}
 ]
}
1 Like
3

Thanks

This works for me