Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why am I unable to find a record by _id in mongodb

I am trying to find a record in mongoDB by it's MongoID "_id" field. I have found examples on how to do it, but can not get it to work. Example:

$recID = "010101010101011";  //would be a valid mongodb _id
$recID = new MongoId((string)$recID);  // I have tried it without the (string) cast too
$cursor = $this->Collection->findOne(array('_id' => $recID));
print_r($cursor);

It outputs:

MongoCursor (
)

Nothing inside.

I have verified everything else is working by changing the "_id" above to a different field such as "firstName" and passing in a first name and I get back valid data.

Why does this not work?

I have even tried searching with $recID as a string, no difference.

Here is what happens from the mongo shell (though I am not sure if I am querying properly):

>
> db.Employee.find({login:"myperson"})
{ "_explicitType" : "project.Employee", "_id" : ObjectId("4e209564203d83940f0000
06"), "active" : true, "addedDate" : "07/15/2011 15:29:21", "domain" : "xxx",
 "id" : ObjectId("4e209564203d83940f000006"), "lastLogin" : "07/20/2011 19:13:36
", "login" : "myperson", "name" : "My Person", "pw" : "", "ulevel" : 9999
}
> db.Employee.find({id:"4e209564203d83940f000006"})
> db.Employee.find({_id:"4e209564203d83940f000006"})
>

Notice nothing returned for id or _id.

like image 967
Scott Szretter Avatar asked Jul 29 '11 00:07

Scott Szretter


1 Answers

Try db.Employee.find({_id:ObjectId("4e209564203d83940f000006")}

like image 85
rafalio Avatar answered Oct 19 '22 09:10

rafalio