MongoDB help | Coding Train, Choo choo! | Page 1

untold sparrow Nov 16, 2022, 5:10 PM

#

select u.`rank`
from
    (select usr.user_id, usr.guild_id, rank() over (order by usr.total_xp desc) `rank` from users usr) u
where u.user_id=123 and u.guild_id=234
``` what could be the equivalent `MongoDB` query of this mysql syntax? sorry I'm not used to mongodb ;-;

lavish cloak Nov 16, 2022, 5:21 PM

#

You can look here for a comparison of SQL and MongoDB query syntax.

#

https://www.mongodb.com/docs/manual/reference/sql-comparison/

SQL to MongoDB Mapping Chart

untold sparrow Nov 16, 2022, 6:29 PM

#

alright thanks i’ll look into it tomorrow

untold sparrow Nov 17, 2022, 2:42 PM

#

how to match _id in aggregate? sql $match: { _id: { userId: 654394128108355594, guildId: 713809761925070861 } } doesn't work

lavish cloak Nov 17, 2022, 3:02 PM

#

Test this:

$match: {
   "_id.userId": 654394128108355594,
   "_id.guildId": 713809761925070861
}

untold sparrow Nov 17, 2022, 3:09 PM

#

nope didn't work

lavish cloak Nov 17, 2022, 3:10 PM

#

Which libary you use to query MongoDB and how looks a sample entry of your data?

untold sparrow Nov 18, 2022, 1:17 PM

#

um I was using MongoDB with Spring boot application and I was executing the queries in Intellij IDE's mongodb console (or playground?).

[
  {
    "_id": {
      "userId": 726189004315295804,
      "guildId": 713809761925070861
    },
    "_class": "me.srin.userbot.database.Users",
    "cooldown": 0,
    "level": 0,
    "name": "srin",
    "totalXp": 0,
    "trainingChannel": 0,
    "trainingCount": 2,
    "xp": 0,
    "xpLimit": 100
  }
]``` this is what a document looks like

#MongoDB help