cosmosdb mongo api not working for some commands

Question

I am using cosmosdb on azure
In that I am using mongodb api
I have a "request" collection inside that there is a "claims" array

If I use this command:

db.getCollection('requests').find({"claims.id": 1002})

It is not working in cosmosdb mongo api but working for local mongo service instance I have hosted.

my request object is as below

{
    "_id" : NumberLong(1001),
    "claims" : [ {
            "type" : "broadband",
            "id" : NumberLong(1002),
            "createdOn" : NumberLong(1462799667905)
              } ]
}

Your code seems mess (as in format), please see how you can enhance its look. — Hima
– Hima, Commented Jun 16, 2017 at 10:58

David Makogon · Accepted Answer · 2017-06-16 14:18:23Z

2

Not all of MongoDB's query syntax / capabilities are implemented. This appears to be such a case.

However, this slight workaround should work for you - I just tested it on my own CosmosDB (MongoDB API) collection:

db.getCollection('request').find({claims: { $elemMatch: { id:1002 }}}).pretty()
{
  "_id" : 1001,
  "claims" : [
    {
      "type" : "broadband",
      "id" : 1002,
      "createdOn" : NumberLong("1462799667905")
    }
  ]
}

Note that you can also call db.request.find() without the need for a call to getCollection().

answered Jun 16, 2017 at 14:18

David Makogon

71k22 gold badges145 silver badges204 bronze badges

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

2 Comments

GeekOnGadgets Over a year ago

David, can you please show the workaround how to update the object inside an array ?

Hafiz Over a year ago

Would be nice to know which if any are implemented :)

Collectives™ on Stack Overflow

cosmosdb mongo api not working for some commands

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related