Question 117080 in Mongodb Question posted in
The official documentation can be found here.

Mongodb – mongoose $in filter with find method is returning empty array

I am using this function

export const getVideoByTag = async (req, res, next) => {
  const tags = req.query.tags?.split(",");
  try {
    const videos = await Video.find({tags: {$in: tags}}).limit(20);
    res.status(200).json(videos);
  }catch (err) {
    next(err);
  }
};

The router path is router.get("/tags", getVideoByTag)

And I am using postman with the endpoint {{host}}/videos/tags?tags=js

And in my database videos are like this

{
"_id":{"$oid":"62f02bff4ec6b4df46b3aced"},
"userId":"62eeaaf26595deb49db004b0",
"title":"Second Video",
"description":"test description",
"imgUrl":"https://dsafawefas.vom",
"videoUrl":"https://heksldawra.com/assets/likes.mp4",
"views":{"$numberInt":"0"},
"tags":["['js', 'horse']"],
"likes":[],
"disLikes":[],
"createdAt":{"$date":{"$numberLong":"1659907071761"}},
"updatedAt":{"$date":{"$numberLong":"1659907071761"}},
"__v":{"$numberInt":"0"}
}

The problem

You can clearly see that there’s a js tag inside the video schema inside my db, but still still it’s returning empty array [] when I use get request inside the postman

Tags:

2

Answers


  1. 0

    Your query seems correct but I think there might be an issue with how you are populating your tags.

    It doesn’t look like its a true array. You are storing the text without actually converting it to an array.

    For instance, here is a sample document I just stored and retrieved. Notice the difference in tags component:

    {
    "_id" : ObjectId("62f10768c20220d872336a6c"),
    "tags" : [ 
        "js", 
        "horse"
    ]
}
    Login or Signup to reply.
  2. 0

    When you update your document, don’t just use $push: {field: array}, you need to use $each

    e.g.

    const updatedTags = ["php", "js"]

..... $push: { tags: { $each: updatedTags }} ....

    MongoDB $each

    Once you update your document correctly, you should be able to perform your query and get desire documents.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search