Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db.matches.aggregate([{
- $match: {
- $or: [{
- $and: [{
- "tournament": "Wimbledon"
- }, {
- "sets.tiebreak": true
- }]
- }, {
- $and: [{
- "tournament": "Roland Garros"
- }, {
- "sets.tiebreak": false
- }]
- }]
- }
- }, {
- $unwind: '$sets'
- }, {
- $match: {
- $or: [{
- $and: [{
- "tournament": "Wimbledon"
- }, {
- "sets.tiebreak": false
- }]
- }, {
- $and: [{
- "tournament": "Roland Garros"
- }, {
- "sets.tiebreak": true
- }]
- }]
- }
- }, {
- $group: {
- "_id": "$_id",
- "tournament": {
- $first: "$tournament"
- },
- "player1": {
- $first: "$player1"
- },
- "player2": {
- $first: "$player2"
- },
- "sets": {
- $push: "$sets"
- }
- }
- }])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement