Minor - P4 Description
Instead of a $ positional operator in projections ( as proposed here: http://jira.mongodb.org/browse/SERVER-828 ), I think that we could use a $elemMatch operator in projections, which will be used similiar to $slice.
An example in pseudo-js:
doc = {'a' : [
,
{'b':2},
{'b':3}],'c' :4}
project( {'a' : [
{'b':1},
{'b':2},
{'b':3}] }, {'a':{$elemMatch:
{'b':2}}} )
will be evaluated to:
{'a' : [
],'c' :4}
project( {'a' : [
{'b':1},
{'b':2},
{'b':3} ] }, {'a':{$elemMatch:{'b':{'$gte':2}}}} )
will be evaluated to:
{'a' : [
,
{'b':3}],'c' :4}
The advantage over the $-operator is that, the projection is completly independent from the matching. So you could match on something completly different and return only the entries you want. Furthermore this should be easier to implement.
The only problem I see is that, you will in many cases repeat yourself, because you want to extract the fields you are querying for.
Attachments
Issue Links
- is related to
-
SERVER-828 Support for selecting array elements in return specifier (projection)
-
- Closed
-
-
DOCS-422 Add doc for $elemMatch operator
-
- Closed
-
- related to
-
SERVER-6613 using $elemMatch projection with $all gives unexpected results
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-