CosmosDB with MongoDB API

Question

Hi I am a newbie on MongoDB and CosmosDB and I try to this in c#

MongoClientSettings settings = MongoClientSettings.FromUrl(
                      new MongoUrl(connectionString)
                    );
                    settings.SslSettings =
                      new SslSettings() { EnabledSslProtocols = SslProtocols.Tls12 };    
    var mongoClient = new MongoClient(settings);
    var mongoDatabase = mongoClient.GetDatabase("MYDATABASE");
    var mongoCollection = mongoDatabase.GetCollection<BsonDocument>("MYCOLLECTION");

    var builder = Builders<BsonDocument>.Filter;            
    var filter = builder.Lt("mac", "001BC50670101BB8") & builder.Gte("date", "2016-09-18T00:00:00Z") & builder.Gte("date", "2017-09-22T00:00:00Z");

    var query = mongoCollection.Find<BsonDocument>(filter).ToList<BsonDocument>();

But when it runs the query on the server I get this error:

Errors":["An invalid query has been specified with filters against path(s) that are not range-indexed. Consider adding allow scan header in the request."

I have found that I should add the "x-ms-documentdb-query-enable-scan" header to my request. But how I can do this?

Maybe Mongo dosen't know what is less than 001BC50670101BB8? — BOR4
– BOR4, Commented Sep 21, 2017 at 8:27

marc_s · Accepted Answer · 2017-09-21 13:45:17Z

2

Solution found in comment section:

Query changed from

builder.Lt("mac", "001BC50670101BB8")

to

builder.Eq("mac", "001BC50670101BB8")

edited Sep 21, 2017 at 13:45

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 21, 2017 at 8:51

BOR4

6304 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

CosmosDB with MongoDB API

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related