how to find document in mongodb collection, if i have ObjectID as string?

-
how to find document in mongodb collection, if i have ObjectID as string?

i tried some variants, but without success

.Match('"_id" : ObjectId("57EB7FD37E58C0C489BFF6F2")')
and

.Match
.BeginObject('_id.$oid')
.Add('$eq', '57EB7FD37E58C0C489BFF6F2')
.EndObject

both does not work.....

Comments

  1. Agustin OrtuSeptember 29, 2016 at 4:45 PM

    /Sub

    ReplyDelete
  2. Aleksandar DjurovicSeptember 30, 2016 at 1:14 AM

    Wow :)
    I'm very happy to post a solution :)

    FCon[DBName][CollectionName].CommandSimple(
    '{ '+
    ' find: "MyCollection", '+
    ' filter: { _id : {"$oid":"57EB7FD37E58C0C489BFF6F2"} }, '+
    '}'
    ).AsJSON;

    now, i have to see, how to exclude only the part that i need.

    ReplyDelete
  3. Aleksandar DjurovicSeptember 30, 2016 at 4:07 AM

    or
    FCon[DBName][MyCollection].Dereference(TJsonOid.Create('57EB7FD37E58C0C489BFF6F2'));

    Both are ok,
    first one better for complex querys on server side.

    ReplyDelete

Post a Comment