Query a parent child relationship by objectids

[MiguelOrtiz]

Hi @Gordian, and welcome to the forum!

Not familiar at all with mongoDB, but this issue is similar also with postgres. I found the below conversation, which is the inverse of what you're trying to achieve.

Use a list of ObjectIds from a Text Input Field

Hi @baran! You might want to try using JSON.parse. In your JS query you can do something like return JSON.parse('{"_id" : {"$in": [{"$oid":"your_oid_here"}]}}') Or, you can pass {{ JSON.parse(getIdList.data) }} to your MongoDB query. As a side note: you might also try using the additionalScope object here. In your JS query you can trigger your MongoDB query with var idList = idListInput.value.split(",").map(id => ({$oid: id})); userQuery.trigger({additionalScope: {idList}}); and then in y…

Which makes me think that you may need to stringify the variable, e.g. {{ JSON.stringify( listProcesses.selectedRow.subprocess_ids ) }} ?

However, this will end up being

{"_id": {$in: [{$oid: "687a69d478b4bc14f555f596","687a69d478b4bc14f555f597"}] } }

rather than

{"_id": {$in: [{$oid: "687a69d478b4bc14f555f596"}, {$oid:"687a69d478b4bc14f555f597"}] } }

So I think the solution may be the below:

{
  "_id": {
    "$in": {{ listProcesses.selectedRow.subprocess_ids.map(id => ({ $oid: id })) }}
  }
}