MongoDB - Query on the last element of an array?

arrays, mongodb, mongodb-query, mongoose, spring-data-mongodb

Solution

I posted on the official Mongo Google group here, and got an answer from their staff. It appears that what I'm looking for isn't possible. I'm going to just use a different schema approach.

Problem

I know that MongoDB supports the syntax `find{array.0.field:"value"}`, but I specifically want to do this for the last element in the array, which means I don't know the index. Is there some kind of operator for this, or am I out of luck? EDIT: To clarify, I want find() to only return documents where a field in the last element of an array matches a specific value.

Original source