Publish Collection with elemMatch all Projection

help
1

I have the following collection:

{
    "_id" : "PkjBLm7KnztyG73ow",
    "teamId" : "jyxxjSX7nuha4YvtG"
},
{
    "_id" : "t3gftjLyudtnkwkBv",,
    "teamId" : "jyxxjSX7nuha4YvtG"
    "projects" : [ 
        "XxqmAnPBn52wtwdaD", 
        "kv4xri4Q9sn94BkmM"
    ]
},
{
    "_id" : "kuAYraMRQtKbshpq3",,
    "teamId" : "jyxxjSX7nuha4YvtG"
    "projects" : [ 
        "XxqmAnPBn52wtwdaD", 
        "iaKJoMikF7k2X56ee"
    ]
},
{
    "_id" : "22Gw5qN8yQ5hgSCfW",,
    "teamId" : "jyxxjSX7nuha4YvtG"
    "projects" : [ 
        "kv4xri4Q9sn94BkmM",
        "iaKJoMikF7k2X56ee"
    ]
}

When I use $elemMatch and $in to publish the collection, I get only the first project :frowning:

Collection.find({
    "teamId" : "jyxxjSX7nuha4YvtG"
    }, {
      fields: {
        projects: { $elemMatch: { $in: ["XxqmAnPBn52wtwdaD", "iaKJoMikF7k2X56ee"]} },
      }
    });

Result:

{
    "_id" : "PkjBLm7KnztyG73ow"
},
{
    "_id" : "t3gftjLyudtnkwkBv",
    "projects" : [ 
        "XxqmAnPBn52wtwdaD", 
    ]
},
{
    "_id" : "kuAYraMRQtKbshpq3",
    "projects" : [ 
        "XxqmAnPBn52wtwdaD", 
    ]
},
{
    "_id" : "22Gw5qN8yQ5hgSCfW",
    "projects" : [ 
        "iaKJoMikF7k2X56ee"
    ]
}

But I want publish all projects. I need the following result:

{
    "_id" : "PkjBLm7KnztyG73ow"
},
{
    "_id" : "t3gftjLyudtnkwkBv",
    "projects" : [ 
        "XxqmAnPBn52wtwdaD", 
    ]
},
{
    "_id" : "kuAYraMRQtKbshpq3",
    "projects" : [ 
        "XxqmAnPBn52wtwdaD", 
        "iaKJoMikF7k2X56ee"
    ]
},
{
    "_id" : "22Gw5qN8yQ5hgSCfW",
    "projects" : [ 
        "iaKJoMikF7k2X56ee"
    ]
}

is this possible and has anybody an example for me? :slight_smile: