MongoDB - Query

mongodb-template-06-query.js

db.search_logs.aggregate(
   [
      {
        $group : {
             _id : { 
                     keyword: "$keyword"
                     , created: { $dateToString: { format: "%Y-%m-%d", date: "$created_at" }  }
                 }
            , users: {
                $push: {
                      username: '$username',
                      keyword: '$_id.keyword',
                      created: '$_id.created',
                      count: { $sum: 1 }
                }
            }
         }
      },
      {
           $match: { '_id.created': { $eq: '2018-07-13' }  }
      },
      {
          $sort: { created_at: -1 }
      }
   ]
)