I am new to Couchbase and currently using flutter and Couchbase Lite to build a search form, I need to add NOT operator inside my query.
Here is my current query and it’s work well, but I don’t know how to add NOT operator to the match function.
QueryBuilder.select([SelectResult.all()])
.from(CouchbaseDB.instance.dbNameLocal, as: objectAlias)
.where(Expression.property(Block.keyString.type)
.from(objectAlias)
.equalTo(Expression.string(objectAlias))
.and(FullTextExpression.index('BlockFTSIndex')
.match('flora AND fauna'))
.groupBy(
[Expression.property(Block.keyString.cardId).from(objectAlias)])
Based on this documentation it support NOT operator, but there are no sample code on how to use it.
I am trying with this code
match('flora AND fauna NOT human')
and it return
malformed MATCH expression: [NOT "human"]