node.js - MongoDB - How to search a value into nested arrays? -


i trying query searches value many sub arrays using mongodb. db schema looks : 

user: [ {   name: "somename",  dvd: [      {        collectionname: "actiondvds",        movies: [         {           _id: objectid(x),          mark: 10        },        {           _id: objectid(y),          mark: 8        }      }     ] } ... ]

i know 3 informations : user.name, dvd.collectioname, movies._id.

for example trying know if there user named "somename", having movie objectid(x) dvd collection named "actiondvds".

i tried query : 

user.findone( {   $and:  [     {name: "somename"},     {dvd : {          $elemematch: { name: "actiondvds" }     },     {movies: {          $elemmatch: { _id: objectid(x) }     }   ] })

any idea ?

this should it, need nest check movies inside dvd, or it'll match movie inside movie collection;

db.user.findone(     {'name':'somename',       'dvd': {$elemmatch: {'collectionname':'actiondvds',                            'movies': {$elemmatch: { '_id': objectid('x')}}}}})

Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

jquery - How would i go about shortening this code? And to cancel the previous click on click of new section? -

my code below changes image people in team sector, can see theres alot of repeated code; there way shorten it? also currently, allows click on sections without turning off clicked one; assume toggle() function, couldn't work other way! still quite new jquery coding, grand!! cheers in advance! $("#team_client_services").click(function () { if ($(".team_client_services").hasclass("team_hide")) { $(".team_client_services").toggleclass("team_hide"); $(".team_client_services2").toggleclass("team_show"); } else { $(".team_client_services").toggleclass("team_hide"); $(".team_client_services2").toggleclass("team_show"); }; }); $("#team_management").click(function () { if ($(".team_management").hasclass("team_hide")) { $(".team_management").toggleclass("team_hide"); $(".team_management2...
Read more