Match beginning of array with another array in mongodb

Question

Let's say I have some documents that have an array like this:

[
  {
    "_id": ObjectId("5a934e000102030405000000"),
    "letters": ["a","b","c","d"]
  },
  {
    "_id": ObjectId("5a934e000102030405000001"),
    "letters": ["a","b"]
  },
  {
    "_id": ObjectId("5a934e000102030405000002"),
    "letters": ["a"]
  },
  {
    "_id": ObjectId("5a934e000102030405000003"),
    "letters": ["x","a","b"]
  }
]

I want to retrieve all the documents whose letters array start with an n length array. For example: ["a","b"]

So the result would be like this:

[
  {
    "_id": ObjectId("5a934e000102030405000000"),
    "letters": ["a","b","c","d"]
  },
  {
    "_id": ObjectId("5a934e000102030405000001"),
    "letters": ["a","b"]
  }
]

I have searched on mongo docs and stack overflow, and the only thing that's close is using $all operator but that's not exactly what I want.

I think it could be done by first slicing the array and then matching it with the query array, but I couldn't find anything.

turivishal · Accepted Answer · 2022-06-03 04:09:29Z

1

You can simply use array index in match query,

check 0 index for a value
check 1 index for b value

db.collection.find({
  "letters.0": "a",
  "letters.1": "b"
})

Playground

answered Jun 3, 2022 at 4:09

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

Comments

Takis · Accepted Answer · 2022-06-03 11:37:14Z

0

Query

slice and take the first 2 of $letters
check if equal with ["a" "b"]

*this is like general solution for any array, to make it work you can replace the 2 with the array size, and the ["a" "b"] with your array

Playmongo

aggregate(
[{"$match": {"$expr": {"$eq": [{"$slice": ["$letters", 2]}, ["a", "b"]]}}}])

edited Jun 3, 2022 at 11:37

answered Jun 3, 2022 at 1:06

Takis

8,7552 gold badges17 silver badges28 bronze badges

Collectives™ on Stack Overflow

Match beginning of array with another array in mongodb

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related