Skip to content

Instantly share code, notes, and snippets.

@tradingbills
Last active March 1, 2018 16:08
Show Gist options
  • Save tradingbills/33c6308f87cfb5a470a9d62fa47b2dd9 to your computer and use it in GitHub Desktop.
Save tradingbills/33c6308f87cfb5a470a9d62fa47b2dd9 to your computer and use it in GitHub Desktop.
mongodb query Col1
var collName= 20180301
// 2018-03-01 00:00:00 to
// 2018-03-01 23:59:59
var dateRange= {"$gte":1519862400,"$lte":1519948799}
var queryDoc; queryDoc.signed_up_at = dateRange
db.getCollection(`${collName}`).aggregate([
{ "$match": queryDoc }
,{ "$group":{ "_id" : null,
// "Plan Names": { "$addToSet": { "api_plan_name" : "$custom_attributes.api_plan_name"}},
"Total no activity" : {"$sum":1}
}}
])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment