MongoDB supports an element operator called $exists which matches documents that have the specified field. It would offset for the lack of support for NULL metadata values.
MongoDB docs: https://www.mongodb.com/docs/manual/reference/operator/query/exists/#mongodb-query-op.-exists
@shubham.pawar thanks for sharing the feedback. Would you be using this type of filter to find rows to update or would this be used a part of a typical search?
@gdj0nes Currently our use case for this filter would be to use it during a typical search; to find similar records where a particular metadata is absent.
Got it thanks for sharing!
hey guys, any updates
I wasted a lot of time trying to get a workaround for this filter, and then found out $exists filter does actually exists or at least works while querying, with absolutely no mention in the docs whatsoever.
@AusafMo thank you for calling this to our attention. We are working on updating our docs to reflect that we do in fact support $exists.
Thanks for finding this!