Problem description

• Server environment: mongo server version 3.0.10

• Content format:

{
 "_id" : ObjectId("582bc1b1421e46e4c14e2be8"),
 "date" : "2016-10-21",
 "path" : [
 {
 "url" : "http://m.xin.com/quanguo/sanling/yishen/?  Q= mitsubishi wing god ",
 "query": "Mitsubishi Wing God",
 "dttime" : "2016-10-21 12:41:36",
 "time_stamp" : 1477024896,
 "platform" : "m"
 },
 {
 "url" : "http://m.xin.com/quanguo/sanling/yishen/?  Q= mitsubishi wing god ",
 "query": "Mitsubishi Wing God",
 "dttime" : "2016-10-21 12:41:36",
 "time_stamp" : 1477024896,
 "platform" : "m"
 }
 ],
 "cid" : "ecabb21f-cb89-992f-79d9-b920427097bf"
 }

• Query statement:

Db.dw _ all _ query _ user _ path.find ({"path.query":/mitsubishi/i}, {"path": {"$ elemmatch": {"query":/mitsubishi /i}}}})

After testing, $elemMatch can only return one document in the array.

• How can all the data in path array be returned?

Solution

Use aggregation

db.dw_all_query_user_path.aggregate(
 {
 $match:{
 "path.query":/ mercedes /i
 }
 },
 {
 $unwind:'$path'
 },
 {
 $match:{
 Query': mercedes-benz /i
 }
 },
 {
 $group:{
 _id:'$_id',
 cid:{$first:'$cid'},
 date:{$first:'$date'},
 path:{$push:'$path'}
 }
 }).pretty()

Finally, the required data format was obtained. Thank you! ! !