xexi · July 18, 2017 06:42
diff --git a/mongo_shell_distinct b/mongo_shell_distinct
 db.collection.aggregate( [
 	{ $match: { 'dept': "service", 'condition': '0' } },
 	{ $group: { _id: { first: "$distinct_col1", second: "$distinct_col1" },  // distinct option
 		id_tag : { $min: "$tag" }, // projection
 		count: { $sum:1 } // group count
 	  }
 	},
 	{ $sort: { '_.id.regdate': 1 }}, // make sure sort by group id // 1 asc
 	{ $skip: 0 },
 	{ $limit: 5 },
 ], { "allowDiskUse" : true }); // if memory problem occured
	db.collection.aggregate( [
	{ $match: { 'dept': "service", 'condition': '0' } },
	{ $group: { _id: { first: "$distinct_col1", second: "$distinct_col1" }, // distinct option
	id_tag : { $min: "$tag" }, // projection
	count: { $sum:1 } // group count
	}
	},
	{ $sort: { '_.id.regdate': 1 }}, // make sure sort by group id // 1 asc
	{ $skip: 0 },
	{ $limit: 5 },
	], { "allowDiskUse" : true }); // if memory problem occured