开发者

Query embedded object with AND in mongodb

开发者 https://www.devze.com 2023-01-21 05:05 出处:网络
Let\'s say there is: {username : \"tom1\", address : { type : 0, year : 2001 }} {username : \"tom2\", address : { type : 1, year : 2011 }}

Let's say there is:

{username : "tom1", address : { type : 0, year : 2001 }}
{username : "tom2", address : { type : 1, year : 2011 }}
{username : "tom3", address : { type : 0, year : 2031 }}
{username : "tom4", address : { type : 1, year : 2002 }}

I'm using Java Driver, how can I query: users who's address.type = 1 AND address.year > 2010 ?

Notice it is in the address object, so normal query {address.type : 1, address.year : {$gt : 2010}} does not work开发者_开发技巧 at all.

Thank you!


Oh I got it:

{address : {type : 1, year : {$gt : 2010}}}
0

精彩评论

暂无评论...
验证码 换一张
取 消