How to do Loopback in array query

Question

I have a table Conversation with property :

"participants": {
  "type": [
    "object"
  ],
  "required": true
}

and the dataSource is MongoDb. I inserted data in format: {participants:[{userId:1},{userId:2}]}. Now I want to find all conversation which userId 1 is in. What i did is using this filter: {where:{participants:{userId:1}}} but it doesn't work like MongoDb query. How can I achieve it?

tashakori · Accepted Answer · 2017-07-18 11:59:22Z

2

you can try this:

app.models.Conversation.find({"where":{"participants":{"elemMatch":{"userId":1}}}}, function(err, res){
    console.log(err, res)
})

answered Jul 18, 2017 at 11:59

tashakori

2,4311 gold badge24 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to do Loopback in array query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related