Sorting nested objects in MongoDB

Question

So I have documents that follow this schema:

{
    _id: String,
    globalXP: {
        xp: {
            type: Number,
            default: 0
        },
        level: {
            type: Number,
            default: 0
        }
    },
    guilds: [{ _id: String, xp: Number, level: Number }]
}

So basically users have their own global XP and xp based on each guild they are in.

Now I want to make a leaderboard for all the users that have a certain guildID in their document.
What's the most efficient way to fetch all the user documents that have the guild _id in their guilds array and how do I sort them afterwards?

I know it might be messy as hell but bare with me here.

J.F. · Accepted Answer · 2020-11-09 16:00:20Z

2

If I've understand well, you only need this line of code:

var find = await model.find({"guilds._id":"your_guild_id"}).sort({"globalXP.level":-1})

This query will return all documentas where guilds array contains the specific _id and sort by player level.

In this way the best level will be displayed first.

Here is an example how the query works. Please check if it work as you expected.

edited Nov 9, 2020 at 16:00

answered Nov 9, 2020 at 15:53

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sorting nested objects in MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related