Conditional projection in mongodb using c# driver

Question

I want to conditionally exclude a field from the projection. Below is my document and I want to execlude projection of Professors if the class type is English.

My document:

{
  "Name": "HumanName",
  "Occupation": "Student",
  "Class": [
    {
      "ClassType": "Math",
      "Professors": [
        {
          "Name": "Jimmy"
        },
        {
          "Name": "Smith"
        }
      ]
    },
    {
      "ClassType": "English",
      "Professors": [
        {
          "Name": "John"
        }
      ]
    }
  ]
}

Exprected result:

{
  "Name": "HumanName",
  "Occupation": "Student",
  "Class": [
    {
      "ClassType": "Math",
      "Professors": [
        {
          "Name": "Jimmy"
        },
        {
          "Name": "Smith"
        }
      ]
    },
    {
      "ClassType": "English",
      "Professors": []
    }
  ]
}

Can we achieve this using C# driver and if we can please share a example.

What have you tried so far? Show us your code and try to explain where you stuck so that we can help you. — Selim Yildiz
– Selim Yildiz, Commented Sep 25, 2020 at 12:02

SJFJ · Accepted Answer · 2020-09-29 11:31:02Z

0

This is how I would go about it. In order for you to remove the group id "artifact" then you would have to project the group output and not include the id.

db.getCollection('MyClass').aggregate( [
{$unwind: '$Class'}, 
{ $project : {  Name : 1 , 
                Occupation : 1, 
                Class : {
                    ClassType:1, 
                    Professors:{
                        $cond: {
                            if: { $eq: ["$Class.ClassType", "English"] },
                            then: [],
                            else: "$Class.Professors"
                                }
                    }
                }
            } 
    },
{$group: {
    _id: '$_id',
    Name: {$first: '$Name'},
    Occupation: {$first: '$Occupation'},
    Class: {$push: '$Class'}
}},

] )

answered Sep 29, 2020 at 11:31

SJFJ

6876 silver badges19 bronze badges

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

1 Comment

SJFJ Over a year ago

I just realized you were looking for a C# driver solution. Sorry!

Collectives™ on Stack Overflow

Conditional projection in mongodb using c# driver

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related