Database

[{"key1":"value1","status":"OK","timestamp":1},{"key2":"value2","status":"OK","timestamp":2},{"key1":"value1","status":"OK","timestamp":3},{"key2":"value2","status":"OK","timestamp":4},{"key1":"value1","status":"OK","timestamp":5},{"key2":"value2","status":"OK","timestamp":6},{"key1":"value1","status":"OK","timestamp":7},{"key2":"value2","status":"OK","timestamp":8},{"key1":"value1","status":"OK","timestamp":9},{"key2":"value2","status":"OK","timestamp":10},{"key1":"value1","status":"OK","timestamp":11},{"key2":"value2","status":"OK","timestamp":12}]

Query

db.collection.aggregate([{$facet:{"myAttrName":[{$match:{$or:[{"key1":"value1"},{"key2":"value2"}],status:"OK"}},{$sort:{timestamp:-1}},{$skip:0},{$limit:10}]}}])

Result