Self Join Json

[greeshma]

{
"id": 1,
"title": "Starters",
"nodes": [{
"id": 11,
"title": "Soup",
"nodes": [{
"id": 111,
"title": "Hot & Sour Chicken",
"nodes": []
}]
},
{
"id": 12,
"title": "Fries",
"nodes": []
}
]
}

Is it possible to generate json as above in progress open edge. I am using 11.7 version. Appreciate if you can provide me any sample codes for slef join json.

 

[ForEachInvoiceDelete]

You can build a dataset in the structure you want using data-relation and then use write-json. If that's what you mean.

 

[greeshma]

You can build a dataset in the structure you want using data-relation and then use write-json. If that's what you mean.

Here the problem is object and array are of same table. I had tried to create data-relation. It throw error saying relation can not be build for same table.

 

[ForEachInvoiceDelete]

Create multiple temp-tables first. Populate them in the structure you want from your original table, then do the above on the temp-tables.