do all of your documents have a
deleted_atfield with an empty string or explicitly marked as anullvalue? Or is the field missing in that document?
all documents have deleted_at and it’s either null or a string
Is it possible that you can just use a N1QL query that uses FTS?
yeah we do that in other places, and that’s why i know we can use a null comparison just like you suggest. it’s just this part is using the SDK builder methods and i don’t want to rewrite it if i don’t have to just to work around this common case.
i guess i could go dig around in the SDK source and see how this code actually works under the covers–trying to avoid that too 