Full text search and comparison operators in the same query
Is it possible to use both full text search (or just wildcards in fields) and operators such as "$gt" in the same query ?
It's not possible to mix full text search and query operators. But fulltext search api has some special (undocumented) powers that might solve this case.. example search parameter json:
"phrase": "description:brown fox AND score:[8 TO *]"
where "description" and "score" are object property names.
Thanks jakolehm for the tip!
If the AND [8 TO *] part can be applied to dates that would indeed solve our problem.
BTW, how might one access the arcane knowledge you seem to possess ?