Using $text search inside $or in mongodb

Question

I'm trying to use $text search inside $or.

await Creators.aggregate([
 {$match: {
  $or: [
    { $creatorId: { $in: [407, 409] } }, 
    { $text: { $search: "Michael"} } ] 
  } }
])

The query won't work. But the $text without $or works fine.

Does anyone have an idea about this? Thank you.

Does this answer your question? [MongoDB: $or a full-text search and an $in](https://stackoverflow.com/questions/26116182/mongodb-or-a-full-text-search-and-an-in) — Puneet Singh, May 18 '20 at 08:35

score 1 · Answer 1 · answered May 18 '20 at 07:42

1

The $text operator expression cannot used in $or or $not expressions when used in aggregation. Refer to doc

answered May 18 '20 at 07:42

nayakam

1 Answers1