skip to content
Alvin Lucillo

Error with text query

/ 1 min read

One of the reasons why a text query fails is you might have a partial filter expression set in the index, which is a portion in the index creation where you specified a fixed value of a field. Partial filter expression makes queries efficient, and it’s paired with a text query if you are expecting them to be always paired. When the fields in the expression aren’t in the query, you might encounter the error similar to below:

error processing query: ns=localhostdb.table1 limit=100Tree: TEXT : query=test, language=none, caseSensitive=0, diacriticSensitive=0 Sort: {} Proj: {} planner returned error :: caused by :: failed to use text index to satisfy $text query (if text index is compound, are equality predicates given for all prefix fields?)