Map Reduce for Free-5947

mr.js

db.logs.remove()

db.logs.insert(
  {"name":"James Carr", 
    "log" : [ 
      { 
        "comment" : "", 
        "time" : ISODate("2011-11-01T21:37:44.897Z"), 
	    "user" : "Brad ************", 
	    "action" : "Call", 
	    "_id" : ObjectId("4eb066a875385d0a71063056") 
      }, 
      { 
        "comment" : "vm em", 
        "time" : ISODate("2011-11-01T21:38:58.751Z"), 
        "user" : "Brad **********", 
        "action" : "Left Message", 
        "_id" : ObjectId("4eb066f275385d0a71063076") 
       }, 
       { 
        "comment" : "Rest period expired, ready to be re-contacted.", 
        "time" : ISODate("2011-11-02T00:41:09.517Z"), 
        "user" : "", 
        "action" : "recycled", 
        "_id" : ObjectId("4eb091a587d45c5073015317") 
       } 
    ], 
} )

// map function
map = function(){
this.log.forEach(
    function(log){
      year = log.time.getFullYear()
      month = log.time.getMonth()
      day = log.time.getDate()
      emit( {name: this.name, year: year, month: month, day: day} , { count : 1 } );
    }
  );
};

// reduce function
reduce = function(key, values) {
  var count = 0;
  values.forEach(function(v) {
    count += v['count'];
  });
  return {count: count};
}

db.logs.mapReduce(map, reduce, {out: "log_results"});