use of "in" in mongodb

Question

I am using mongodb in vb.net

I need to send more than one resource_id similar to "in" in sql.

please help.

My Codes are:

Dim ConnString as String=ConfigurationManager.AppSettings("ConnStringMongo")
Dim server As MongoServer=MongoServer.Create(Connstring)
Dim ceilometer As MongoDatabase=server.GetDatabase("ceilometer")

Dim query=New QueryDocument()
query.Add("user_id","Jewel")

'' Is it possible? or how can i achieve this

 query.Add("resource_id","in('100','200')") 



Dim Docs=ceilometer.GetCollection("meter").Find(query)

chridam · Accepted Answer · 2015-03-30T15:19:55.710

1

You could do something like:

Dim resource_ids = New BsonValue() {"100", "200"}
Dim query = Query.And(
    Query.EQ("user_id", "Jewel"),
    Query.In("resource_id", resource_ids)
)

Dim Docs = ceilometer.GetCollection("meter").Find(query)

edited Mar 30 '15 at 15:19

answered Mar 30 '15 at 15:11

chridam

100,957
23
236
235

then how can i get collection by this query? Dim Docs=ceilometer.GetCollection("meter").Find(query) – Syed Md. Kamruzzaman Mar 30 '15 at 15:16
one thing, resource_ids from my side is dynamic and i am suffering here adding double quote, please help – Syed Md. Kamruzzaman Mar 30 '15 at 16:10
Your other issue is not clear, can you please create a new question outlining the problem you are having and include an example if you can. – chridam Mar 30 '15 at 16:48
chridam, here's my another question, http://stackoverflow.com/questions/29352053/use-of-double-quotes-as-string – Syed Md. Kamruzzaman Mar 30 '15 at 17:04
Ok, let me have a look at it in a bit and will try to help you solve it. – chridam Mar 30 '15 at 17:18

use of "in" in mongodb

1 Answers1