Mongoose Query: how to find object array

Question

If you send json data in the following format, the server tries to go through the item document of mongodb and write the code that returns the data with the same userId and exactly the same json data received by itemTag.

I have this schema:

var subSchema = mongoose.Schema({
  main:Number,
  sub:Number,
  color:Number
},{ _id : false });

var ItemSchema = new Schema({
    userId:String,
    date:String,
    itemTag: [subSchema]
}, { versionKey: false });

db data :

{ 
   "_id" : ObjectId("58ba81eea341c37ed7268703"),
   "date" : "20170304_175923", 
   "userId" : "aaa", 
   "itemTag" : [ 
       { 
           "main" : 3, 
           "sub" : 7,  
           "color" : 1
       }, { 
           "main" : 3, 
           "sub" : 1,  
           "color" : 11
       }, { 
           "main" : 4, 
           "sub" : 4,  
           "color" : 1
       }, {
           "main" : 5, 
           "sub" : 2,  
           "color" : 1
       } 
    ] 
},
{ 
   "_id" : ObjectId("58ba81eea341c37ed7268723"),
   "date" : "20170305_125923", 
   "userId" : "aaa", 
   "itemTag" : [ 
       { 
           "main" : 3, 
           "sub" : 7,  
           "color" : 1

       }, { 
           "main" : 2, 
           "sub" : 2,
           "color" : 2
       } 
    ] 
}

**and client send json data : ** server get req.body.userId req.body.itemTag

{ 
    "userId":"aaa",
    "itemTag":[{
        "main":3,
        "sub":7,
        "color":1
    },{
        "main":4,
        "sub":4,
        "color":1
    }]
}

and i want get :

{ 
   "_id" : ObjectId("58ba81eea341c37ed7268703"),
   "date" : "20170304_175923", 
   "userId" : "aaa", 
   "itemTag" : [ 
       { 
           "main" : 3, 
           "sub" : 7,  
           "color" : 1
       }, { 
           "main" : 3, 
           "sub" : 1,  
           "color" : 11
       }, { 
           "main" : 4, 
           "sub" : 4,  
           "color" : 1
       }, {
           "main" : 5, 
           "sub" : 2,  
           "color" : 1
       } 
    ] 
}

I didn't understand what you want to achieve, can you explain again? — Ravi Shankar Bharti
– Ravi Shankar Bharti, Commented Mar 6, 2017 at 7:55
I want to find the same value in the db as the following itemTag array. { "ItemTag": [{ "Main": 3, "Sub": 7, "Color": 1 }, { "Main": 3, "Sub": 1, "Color": 11 }] } — greatsk
– greatsk, Commented Mar 6, 2017 at 8:01

Parshuram Kalvikatte · Accepted Answer · 2017-03-06 12:01:47Z

1

Try This

   db.collection.find(
        {"userId" : req.body.userId,"itemTag.main" : req.body.itemTag},
        {itemTag : 1,userId:1})
        .sort(sortQuery)
        .skip(skipPage)
        .limit(16)

OR

 db.collection.find(
        {"userId" : req.body.userId,"itemTag":{ "$elemMatch" : {main : req.body.itemTag}}},
        {itemTag : 1,userId:1})
        .sort(sortQuery)
        .skip(skipPage)
        .limit(16)



//Note : In collection you need to write your collectionName

3 ) - If you want a specific elements from array

db.collection.find(
  {"userId" : req.body.userId,"itemTag":{ "$elemMatch" : {main : req.body.itemTag}}},
     {"itemTag.$.main"  : 1,userId:1})
     .sort(sortQuery)
    .skip(skipPage)
    .limit(16)

edited Mar 6, 2017 at 12:01

answered Mar 6, 2017 at 7:33

Parshuram Kalvikatte

1,6465 gold badges23 silver badges45 bronze badges

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

2 Comments

greatsk Over a year ago

thanks.. but i got this message : { "message": "Cast to number failed for value \"[ { main: 3, sub: 7, color: 1 }, { main: 4, sub: 4, color: 1 } ]\" at path \"main\" for model \"Item\"", "name": "CastError", "stringValue": "\"[ { main: 3, sub: 7, color: 1 }, { main: 4, sub: 4, color: 1 } ]\"", "kind": "number",

Parshuram Kalvikatte Over a year ago

Please post what query you are execute ,, and make sure that all documents fields( "main" , "sub" and "color" are number field)

s7vr · Accepted Answer · 2017-03-06 16:05:15Z

0

You can try below find query. The query uses $all with $elemMatch to return rows when there is entry for each of the values in the array.

var rItemTag = req.body.itemTag
var qItemTag = rItemTag.map(value => ({"elemMatch": value}));
db.collection.find({itemTag: {$all: qItemTag}})

edited Mar 6, 2017 at 16:05

answered Mar 6, 2017 at 15:16

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

Comments

Vishal · Accepted Answer · 2017-03-05 15:35:58Z

0

I am not sure, but you should use:

itemTag.$.main syntax

For getting first item in the array you can use:

itemTag.$0.main

For second item in the array:

itemTag.$1.main

and so on.......

answered Mar 5, 2017 at 15:35

Vishal

6,42814 gold badges90 silver badges166 bronze badges

Collectives™ on Stack Overflow

Mongoose Query: how to find object array

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related