MongoDB avoid duplicates using $addToSet in aggregation pipeline -


there aggregation pipeline:

db.getcollection('yourcollection').aggregate(     {         $unwind: {             path: "$dates",             includearrayindex: "idx"         }     },     {         $project: {             _id: 0,             dates: 1,             numbers: { $arrayelemat: ["$numbers", "$idx"] },             goals: { $arrayelemat: ["$goals", "$idx"] },             durations: { $arrayelemat: ["$durations", "$idx"] }         }     } )

which perform on following data (sample documents):

{     "_id" : objectid("52d017d4b60fb046cdaf4851"),     "dates" : [         1399518702000,         1399126333000,         1399209192000,         1399027545000     ],     "dress_number" : "4",     "name" : "j. evans",     "numbers" : [         "5982",         "5983",         "5984",         "5985"     ],     "goals": [         "1",         "0",         "4",         "2"     ],    "durations": [        "78",        "45",        "90",        "90"    ] }  {     "_id" : objectid("57e250c1b60fb0213d06737c"),     "dates" : [         "1399027545000",         "1399101432000",         "1399026850000",         "1399904504000"     ],     "dress_number" : "6",     "name" : k. mitnick,     "numbers" : [         "0982",         "0981",         "0958",         "0982"     ],     "durations" : [         98,         110,         66,         92     ],     "goals" : [         "2",         "3",         "0",         "1"     ] }

the query works good, there duplicate records i'm trying use $addtoset operator avoid duplicates:

db.getcollection('yourcollection').aggregate(         {             $match: {                 "number": number             }         },         {             $unwind: {                 path: "$dates",                 includearrayindex: "idx"             }         },          $group: {                     _id: '$_id',                     dates: { $addtoset: '$dates' }         },         {             $project: {                 _id: 0,                 dates: 1,                 numbers: { $arrayelemat: ["$numbers", "$idx"] },                 goals: { $arrayelemat: ["$goals", "$idx"] },                 durations: { $arrayelemat: ["$durations", "$idx"] }             }         }     )

but got dates (other field null)

{ dates:       [ '1399026850000',        '1399101432000',        '1399027545000',        '1399904504000',        '1399024474000',        '1399126333000' ],     numbers: null,     goals: null,     durations: null },   { dates:       [ '1399027545000',        '1399024474000',        '1399518702000',        '1399126333000',        '1399209192000',        '1399356651000' ],     numbers: null,     goals: null,     conversation_durations: null },   { dates:       [ '1399026850000',        '1399101432000',        '1399027545000',        '1399904504000',        '1399024474000' ],     numbers: null,     goals: null,     durations: null }

does know problem?

you need include fields within $group pipeline using $first operator follows:

db.getcollection('yourcollection').aggregate([     { "$unwind": "$dates" },     {         "$group": {             "_id": "$_id",             "dates": { "$addtoset": "$dates" },             "numbers": { "$first": "$numbers" },             "goals": { "$first": "$goals" },             "durations": { "$first": "$durations" }         }     },     { "$unwind": {             "path": "$dates",             "includearrayindex": "idx"     } },     {         "$project": {             "_id": 0,             "dates": 1,             "numbers": { "$arrayelemat": ["$numbers", "$idx"] },             "goals": { "$arrayelemat": ["$goals", "$idx"] },             "durations": { "$arrayelemat": ["$durations", "$idx"] }         }     } ])

or using $setunion eliminate duplicates as:

db.getcollection('yourcollection').aggregate([     {         "$project": {             "_id": 0,             "dates": { "$setunion": ["$dates", "$dates"] },             "numbers": 1,             "goals": 1,             "durations": 1         }     }     { "$unwind": {             "path": "$dates",             "includearrayindex": "idx"     } },     {         "$project": {             "_id": 0,             "dates": 1,             "dateindex": "$idx",             "numbers": { "$arrayelemat": ["$numbers", "$idx"] },             "goals": { "$arrayelemat": ["$goals", "$idx"] },             "durations": { "$arrayelemat": ["$durations", "$idx"] }         }     } ])

-

Comments

Post a Comment

Popular posts from this blog

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more