How to query mongodb with DBRef

[Anonymous]

Hello,

I have a database structure for Collection1 with a field with dbref like this:

"field_name" : DBRef("Collection2", ObjectId("5c3e25aaf1a79a001f1dbb08"), "database_name")

I want to get only the ObjectId of the field_name with tMongoDBInput but I can't do it.

With MongoShell, I can do it with this request :

db.Collection1.find({},{"Collection2.$id":1})

Anyone has any idea? Thanks.

[Anonymous]

Hello,

Are you able to use the tMongoDBRow component to run a simple command like the following: "db.TalendTest.find()"?

Best regards

Sabrina