How to search for a string in an array of objects in MongoDB with C#

Question

I have the following record in my MongoDB. I want to search for a string in the "monday" fields. I want to search the "learningexperience" field to return any documents that matches a certain word in that field.

Not sure how to do it using MongoDB/C#. Any help would be fantastic.

{
    "_id" : ObjectId("59ee623844bd6b042809d492"),
    "title" : "Zebra Room (2017-10-30)",
    "weekcommencing" : "2017-10-30", 
    "monday" : [ 
        {
            "categoryid" : "59ee610244bd6b042809d48d",
            "category" : "Culture & Community",
            "learningexperience" : "Dress up to reflect where i am from. Children are asked to dress in the national uniform of their origins."
        }, 
        {
            "categoryid" : "59edca4344bd6d1e200c3c32",
            "category" : "Literacy & Numeracy",
            "learningexperience" : "Today the children will be focusing on simple additions. For those more advance we will also have subtractions in place."
        }
]
}

MongoDB C# driver, query by an array element using regex?

Neil Lunn
– Neil Lunn

2017-11-02 23:33:43 +00:00
Commented Nov 2, 2017 at 23:33 — Neil Lunn
– Neil Lunn, Commented Nov 2, 2017 at 23:33

Bùi Đức Khánh · Accepted Answer · 2017-11-03 03:38:40Z

1

If you want to search it with something like %keyword%. You may try this

db.tablename.find({"monday.learningexperience": /.*keyword.*/})

For C# you may try this filter (mongodb c# driver 2.0 or higher )

Builders<tablename>.Filter.Regex("monday.learningexperience", new BsonRegularExpression("keyword", "i"));

edited Nov 3, 2017 at 3:38

answered Nov 3, 2017 at 3:30

Bùi Đức Khánh

4,6787 gold badges32 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

How to search for a string in an array of objects in MongoDB with C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related