My user has this field : <pre class="prettyprint"><code>interestedIn: [{ type: String, enum: [ 'art', 'sport', 'news', 'calture', ... ], }], </code></pre> and my video has this field: <pre class="prettyprint"><code>categories: [{ type: String, enum: [ 'art', 'sport', 'news', 'calture', ... ], }], </code></pre> So I need a Video query that has the following conditions: <ul> <li>Query to all videos and sort by values in req.user.interestedIn first.</li> <li>Rest of the videos that are not match to req.user.interestedIn get in the last.</li> </ul> I got this far with said query: <pre class="prettyprint"><code>Video.aggregate([ { '$match': {}}, { '$unwind': '$categories' }, { '$match': {categories: {$in: req.user.interestedIn}}}, { '$group': { '_id': '$categories', 'categories': { '$push': '$categories' } }}, { '$sort': { 'categories': 1 } } ]) </code></pre> This is the result: <pre class="prettyprint"><code> "videos": [ { "_id": "art", "categories": [ "art", "art", "art", "art", "art", "art", "art", "art", "art", "art", "art", "art", "art", "art" ] }, { "_id": "news", "categories": [ "news", "news", "news", "news", "news", "news", "news", "news", "videos": [ { "_id": "art", "categories": [ "art", "art", "art", "art", "art", "art", "art", "art", "art", "art", "art", "art", "art", "art" ] }, { "_id": "news", "categories": [ "news", "news", "news", "news", "news", "news", "news", "news", "news", "news", "news", "news", "news", "news" ] } ] } </code></pre>

You can use <code>$setIntersection</code> to extract the matching elements followed by <code>$size</code> to count the matches. <code>$sort</code> descending documents on number of matches. Something like <pre class="prettyprint"><code>Video.aggregate([ {"$addFields":{ "numofmatches":{"$size":{"$setIntersection":["$categories", req.user.interestedIn]}}}}, {"$sort":{"numofmatches":-1}} ]) </code></pre>

MongoDB Aggregate: Sorting by existing values first

My user has this field :

interestedIn: [{
        type: String,
        enum: [
            'art',
            'sport',
            'news',
            'calture',
            ...
        ],
    }],

and my video has this field:

categories: [{
            type: String,
            enum: [
                'art',
                'sport',
                'news',
                'calture',
                ...
            ],
        }],

So I need a Video query that has the following conditions:

Query to all videos and sort by values in req.user.interestedIn first.
Rest of the videos that are not match to req.user.interestedIn get in the last.

I got this far with said query:

Video.aggregate([

        { '$match': {}},
        { '$unwind': '$categories' },
        { '$match': {categories: {$in: req.user.interestedIn}}},
        { '$group': {
            '_id': '$categories',
            'categories': { '$push': '$categories' }
        }},
        { '$sort': { 'categories': 1 } }
    ])

This is the result:

   "videos": [
        {
            "_id": "art",
            "categories": [
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art"
            ]
        },
        {
            "_id": "news",
            "categories": [
                "news",
                "news",
                "news",
                "news",
                "news",
                "news",
                "news",
                "news",
   "videos": [
        {
            "_id": "art",
            "categories": [
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art",
                "art"
            ]
        },
        {
            "_id": "news",
            "categories": [
                "news",
                "news",
                "news",
                "news",
                "news",
                "news",
                "news",
                "news",
                "news",
                "news",
                "news",
                "news",
                "news",
                "news"
            ]
        }
    ]
}

How do I sort data in MongoDB aggregate?

In MongoDB, the $sort stage is used to sort all the documents in the aggregation pipeline and pass a sorted order to the next stage of the pipeline. Lets take a closer look at the above syntax: The $sort stage accepts a document that defines the field or fields that will be used for sorting.

How do I sort an array in MongoDB aggregation?

To sort the whole array by value, or to sort by array elements that are not documents, identify the input array and specify 1 for an ascending sort or -1 for descending sort in the sortBy parameter.

What does $first in MongoDB?

This means $first returns the first order type for the documents between the beginning of the partition and the current document.

You can use $setIntersection to extract the matching elements followed by $size to count the matches.

$sort descending documents on number of matches.

Something like

Video.aggregate([ 
  {"$addFields":{ "numofmatches":{"$size":{"$setIntersection":["$categories", req.user.interestedIn]}}}}, 
  {"$sort":{"numofmatches":-1}} 
])

MongoDB Aggregate: Sorting by existing values first

Tags:

node.js

mongodb

mongoose

aggregation-framework

Babak Abadkheir

People also ask

1 Answers

s7vr

Recent Activity

Donate For Us

MongoDB Aggregate: Sorting by existing values first

Tags:

node.js

mongodb

mongoose

aggregation-framework

Babak Abadkheir

People also ask

1 Answers

s7vr

Related questions

Recent Activity

Donate For Us