mongodb query on DBRef type

[willem dhaeseleer]

How do I turn this query in a valid mongodb Query in mongodb shell.

{ 'cars.owner.$ref' : 'users' } 

cars.owner is a DBRef here, but $ref is invalid

I get this error:

"$err" : "Positional operator does not match the query specifier."

My objective here is to figure out if cars are "owned" by users consistently, of if cars can be owned by other collections as well. 

Stackoverflow question: 

http://stackoverflow.com/questions/31753058/mongodb-query-on-dbref-type

[Doug Reese]

From stackoverflow answer http://stackoverflow.com/questions/31753058/mongodb-query-on-dbref-type/31794061#31794061

You can query the DBRef in the Mongo shell, but you have to use the DBRef() function. The reference must include at least the $ref and $id. When cars.owner is a reference to a document in the users collection, a query to find all cars where owner is a certain _id might look like (assuming both collections are in the same database):

db.cars.find({ "owner" : DBRef("users", ObjectId("<user _id value>")) })

The $ref and $id values cannot be queried directly. The DBRef is most useful in the case where there are multiple references to different collections in the same document. Using DBRef might be overkill when there is only one reference in the document.

If you need to reference different collections in your owners field, you are probably better served by using separate owner_collection and owner_id fields. The query to find all owners that are not users would then be a standard query.

Doug