MongoDB : aggregation framework : $match between fields

by

Hmm without much testing on my end I will say you can use $cmp for this:

http://docs.mongodb.org/manual/reference/aggregation/cmp/#_S_cmp

db.test.aggregate([
    {$project: {
        // All your other fields here
        cmp_value: {$cmp: ['$a', '$b']}
    }},
    {$match: {cmp_value: {$gt: 0}}} 
])

There might be a better way but I haven’t got a MongoDB installation near me to test.

More Related Contents:

  1. Get names of all keys in the collection
  2. How to filter array in subdocument with MongoDB [duplicate]
  3. MongoDB: Combine data from multiple collections into one..how?
  4. mongodb group values by multiple fields
  5. Find in Double Nested Array MongoDB
  6. Multiple join conditions using the $lookup operator
  7. Conditional $sum in MongoDB
  8. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  9. Get a count of total documents with MongoDB when using limit
  10. exclude fields in $lookup aggregation
  11. How to sum every fields in a sub document of MongoDB?
  12. Add some kind of row number to a mongodb aggregate command / pipeline
  13. MongoDB group by array inner-elements
  14. Exception: can’t convert from BSON type EOO to Date
  15. MongoDB sort documents by array elements
  16. Mongodb Aggregation Framework: Does $group use index?
  17. How to return just the nested documents of an array from all documents
  18. MongoDB: how to parse date in 3.6 mongoDb version?
  19. convert iso date to timestamp in mongo query
  20. Using $slice operator to get last element of array
  21. Geospatial $near within current document field value
  22. Mongodb aggregation pipeline how to limit a group push
  23. Find documents whose array field contains at least n elements of a given array
  24. Generating a Structure for Aggregation
  25. Mongodb concat int and string
  26. Export mongodb aggregation framework result to a new collection
  27. mongodb aggregate query isn’t returning proper sum on using $sum
  28. MongoDB aggregate by field exists
  29. MongoDB {aggregation $match} vs {find} speed
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment