Mongo db find string in a list with .net

Question

I have several records in Posts collection which has Tags field as

"Tags" : [ "Xyr,zau,iRS" ]

and I want to find all posts containing tag I send to a function. What is the right way to do it?

Some of the things I have tried and coun't retrieve any data are,

tag as string parametre

var builder = Builders<Post>.Filter;
var filter = builder.Eq("Tags", tag);

var filter = new BsonDocument("Tags", new BsonDocument("$eq", tag));

var filter = new BsonDocument("Tags", new BsonDocument("$in", tag)); // That one somehow generated an error

var filter= new BsonDocument("Tags", tag);

jhmt · Accepted Answer · 2015-11-02 05:02:59Z

1

Assuming your Tags filed is like this:

"Tags" : [ "Xyr", "zau", "iRS" ]

Then you can use "$in" query in MongoDB driver 2.0 like this:
API Documentation

var filter = Builders<Post>.Filter.In("Tags", new string[] { tag });

edited Nov 2, 2015 at 5:02

answered Nov 1, 2015 at 21:03

jhmt

1,4211 gold badge11 silver badges15 bronze badges

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

3 Comments

Jullien Over a year ago

it seems you are right, it should be the way you have shown but it is not at the moment. Better fix that somehow and then try find().

Jullien Over a year ago

thank you for pointing out my mistake on Tags. Inserting Tags property in the very first place to mongodb, sorted out all my find issues.

jhmt Over a year ago

@Lapsens Glad to hear that.

Collectives™ on Stack Overflow

Mongo db find string in a list with .net

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related