Using objectid type field, foreign key (MONGODB)

[Daniel_Duarte]

Hello everyone, first I would like to congratulate you on the tool, I have used it a lot, but a decisive factor in keeping the tool as the main means of development is the fact of the problem with mongo that I have read about in other topics, I would like to know if there is already any solution, I need to search via find or aggregate or any other way for an object using the foreign key, that is, it is not a “_id” field but any other name, and I can’t do it, even typing it via the javascript code node, has anyone gone through the same thing? problem, what was the solution?

[EmeraldHerald]

Hi @Daniel_Duarte Welcome to the community

While this is a feature request (and I’ll move it to the right forum for it so our product team can get their eyes on it), there is a workaround:

MongoDB update field value as ObjectId

let’s say you want to do a query from a id. Choose the Find operation Choose the Collection you want to get data from and write the expression like: { "$expr": { "$eq": ["$_id", { "$toObjectId": "{{$json["someId"]}}" }] } } this expression will convert a string to a ObjectId. @gravitoad do you need something different? Just let me know.

That should help you out in the meantime!

[Daniel_Duarte]

Thanks for the answer, this answer above doesn’t answer because when I use this in a more complex aggregate, it complains something about top level and so on.