Database

[{"_id":1,"name":"user1","userActivities":[{"actionTaken":"Sign in.","progress":"Success."},{"actionTaken":"logout","progress":"Success."}]},{"_id":2,"name":"user2","userActivities":[{"actionTaken":"Sign in.","progress":"Success."},{"actionTaken":"logout","progress":"Success."}]},{"_id":3,"name":"user3","userActivities":[{"actionTaken":"Sign in.","progress":"Success."},{"actionTaken":"logout","progress":"Success."}]},{"_id":4,"name":"user4","userActivities":[{"actionTaken":"Sign in.","progress":"Success."},{"actionTaken":"logout","progress":"Success."}]},{"_id":5,"name":"user5","userActivities":[{"actionTaken":"Sign in.","progress":"Success."},{"actionTaken":"logout","progress":"Success."}]},{"_id":6,"name":"user6","userActivities":[{"actionTaken":"Sign in.","progress":"Success."},{"actionTaken":"logout","progress":"Success."}]},{"_id":7,"name":"user7","userActivities":[{"actionTaken":"Sign in.","progress":"Success."},{"actionTaken":"logout","progress":"Success."}]},{"_id":8,"name":"user8","userActivities":[{"actionTaken":"Sign in.","progress":"Success."},{"actionTaken":"logout","progress":"Success."}]}]

Query

db.collection.aggregate([{"$match":{"userActivities":{"actionTaken":"Sign in.","progress":"Success."}}},{"$sort":{"name":-1}},{"$project":{"name":1,"userActivities":{"$filter":{"input":"$userActivities","as":"userActivities","cond":{"$eq":["$$userActivities.actionTaken","Sign in."]}}}}},{"$skip":2},{"$limit":2}])

Result