How to sort array inside collection record in MongoDB?

by

You will need to manipulate the embedded array in your application code or using the new Aggregation Framework in MongoDB 2.2.

Example aggregation in the mongo shell:

db.students.aggregate(
    // Initial document match (uses index, if a suitable one is available)
    { $match: {
        _id : 1
    }},

    // Expand the scores array into a stream of documents
    { $unwind: '$scores' },

    // Filter to 'homework' scores 
    { $match: {
        'scores.type': 'homework'
    }},

    // Sort in descending order
    { $sort: {
        'scores.score': -1
    }}
)

Sample output:

{
    "result" : [
        {
            "_id" : 1,
            "name" : "Aurelia Menendez",
            "scores" : {
                "type" : "homework",
                "score" : 71.76133439165544
            }
        },
        {
            "_id" : 1,
            "name" : "Aurelia Menendez",
            "scores" : {
                "type" : "homework",
                "score" : 34.85718117893772
            }
        }
    ],
    "ok" : 1
}

More Related Contents:

  1. Sorting array of object based on range of Numbers of String [closed]
  2. Convert string into several integer arrays [duplicate]
  3. consider a string which has question marks, numbers , letters [closed]
  4. Sort array of objects by string property value
  5. How to sort an array of integers correctly
  6. Javascript Array.sort implementation?
  7. How to sort 2 dimensional array by column value?
  8. Sorting an array of objects by property values
  9. Sort an array of object by a property (with custom order, not alphabetically)
  10. How to sort numbers correctly with Array.sort()? [duplicate]
  11. Sorting objects by property values
  12. How do you put an image file in a json object?
  13. Javascript sort function. Sort by First then by Second
  14. Sort Array by ISO 8601 date
  15. How to sort an associative array by its values in Javascript?
  16. Sort an array with arrays in it by string
  17. What is the most efficient way to sort an Html Select’s Options by value, while preserving the currently selected item?
  18. Sort an array based on another array of integers
  19. How to sort an array based on the length of each element?
  20. Javascript – Sort Array of objects by 2 Properties
  21. Sort array containing objects based on another array [duplicate]
  22. Reordering arrays
  23. Javascript array sort and unique
  24. Populate nested object from array?
  25. use Lodash to sort array of object by value
  26. Sorting an Array of JavaScript Objects a Specific Order (using existing function)
  27. sorting object Sunday to Saturday in javascript
  28. Javascript: Sort array of arrays by second element in each inner array
  29. How to sort a JavaScript array of objects by nested object property?
  30. How to sort an array of objects by date?

Leave a Comment