How do I query a set of objects with an array of values in mongoose?

Question

I have a schema like this

const rankSchema = new Schema(
  {
    rank: { type: Object, default: {} },
    lastUpdated: { type: Date, default: Date.now() },
  },
  { minimize: false }
);

And my database has an object 'rank' with many other objects inside of it like this.

rank: {
  Person1: { Stat1: 2, Stat2: 0, Stat3: 0, Stat4: 2, Stat5: 4 },
  Person2: { Stat1: 4, Stat2: 0, Stat3: 0, Stat4: 2, Stat5: 2 },
  Person3: { Stat1: 1, Stat2: 0, Stat3: 0, Stat4: 2, Stat5: 1 },
  Person4: { Stat1: 2, Stat2: 0, Stat3: 0, Stat4: 2, Stat5: 3 }
}

Now I have an array of strings that contains a few of these people

['Person1', 'Person2']

I want to be able to find all the person objects in that array and return their stats. So essentially the final output after using the array of strings would be

Person1: { Stat1: 2, Stat2: 0, Stat3: 0, Stat4: 2, Stat5: 4 },
Person2: { Stat1: 4, Stat2: 0, Stat3: 0, Stat4: 2, Stat5: 2 }

I tried using $in and various different queries but nothing seems to work and I am stumped.

Thanks

Why not use an array for ranks instead of nested objects?

Parth Shah
– Parth Shah

2020-07-07 09:26:47 +00:00
Commented Jul 7, 2020 at 9:26 — Parth Shah
– Parth Shah, Commented Jul 7, 2020 at 9:26
@ParthShah That would be the better option...

BillTaha
– BillTaha

2020-07-07 09:39:11 +00:00
Commented Jul 7, 2020 at 9:39 — BillTaha
– BillTaha, Commented Jul 7, 2020 at 9:39

mickl · Accepted Answer · 2020-07-07 09:29:28Z

2

You could use a combination of $objectToArray and $arrayToObject to filter your object by dynamic field names but if your parameters are known when you're building your query then it's easier to use regular .find() and apply projection:

db.collection.find({},{ "rank.Person1": 1,  "rank.Person2": 1})

let input = ['Person1', 'Person2'];
let entries = input.map(p => ([`rank.${p}`, 1]))
let projection = Object.fromEntries(entries);
console.log(projection);

Mongo Playground

answered Jul 7, 2020 at 9:29

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

How do I query a set of objects with an array of values in mongoose?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related