Parse Dynamic Multiple Choice into JSON object

I have tried, e.g., also

let myMi := numbers(Elements);
let entries := [];
for i in myMi do
    let tmp_items := (select elements where number(Id) = i);
    if count(tmp_items) > 0 then
        let entryId := first(tmp_items).'parent entry'.'testifies to events'.'testifies to event';
        let elementsArray := [];
        for tmp_item in tmp_items do
            let element := {
                text: tmp_item.text,
                label: tmp_item.'has label'.label
            };
            elementsArray := elementsArray + element;
        end;
        let entry := {
            entry: entryId,
            elements: elementsArray
        };
        entries := entries + entry;
    end;
end;
formatJSON(entries)

Thank you so much. This is certainly the way to go, yet, I don't manage to get what I need.

I think it has to do with the DMC. It's on a table 'events' and lists 'elements' that are linked to 'entries' via 'parent entry'.

so, the second loop in you example is relative to 'elements' but actually I would need to start from 'entries' so that the elements are grouped by entry.

This code, e.g. does in a much better way something similar to my initial approach:

let myMi := for loop1 in numbers(Elements) do
        record(elements,loop1)
    end;
myMi.{
    entry: 'parent entry',
    elements: {
        text: text,
        label: 'has label'.label
    }
}

Result:

[{"entry":1212,"elements":{"text":"Sancti Stephani de oculo","label":"PLACE"}},{"entry":1212,"elements":{"text":"24 cum incertis 40 D","label":"FINANCIAL"}},{"entry":1213,"elements":{"text":"Romae","label":"LOCATION"}},{"entry":1213,"elements":{"text":"Oxonen","label":"DIOCESE"}},{"entry":1213,"elements":{"text":"Joannes albarez","label":"SUCCESSOR"}}]

Any idea how I can put this upside down?

entry, elements: [{label, text},{label, text}],...

Yes, this did the trick! Wonderful.

let myMi := for loop1 in numbers(Elements) do
        record(elements,loop1)
    end;
let myMientries := unique(myMi.'parent entry');
myMientries.{
    entry: number(ID),
    elements: for loop2 in myMi do
        {
            Id: loop2.number(Id),
            text: loop2.text,
            label: loop2.'has label'.label
        }
    end
}

will lead to

[{
        "entry": 1212,
        "elements": [{
                "Id": 15620,
                "text": "Sancti Stephani de oculo",
                "label": "PLACE"
            }, {
                "Id": 15624,
                "text": "24 cum incertis 40 D",
                "label": "FINANCIAL"
            }, {
                "Id": 15626,
                "text": "Romae",
                "label": "LOCATION"
            }, {
                "Id": 15627,
                "text": "Oxonen",
                "label": "DIOCESE"
            }, {
                "Id": 15628,
                "text": "Joannes albarez",
                "label": "SUCCESSOR"
            }
        ]
    }, {
        "entry": 1213,
        "elements": [{
                "Id": 15620,
                "text": "Sancti Stephani de oculo",
                "label": "PLACE"
            }, {
                "Id": 15624,
                "text": "24 cum incertis 40 D",
                "label": "FINANCIAL"
            }, {
                "Id": 15626,
                "text": "Romae",
                "label": "LOCATION"
            }, {
                "Id": 15627,
                "text": "Oxonen",
                "label": "DIOCESE"
            }, {
                "Id": 15628,
                "text": "Joannes albarez",
                "label": "SUCCESSOR"
            }
        ]
    }
]

Ah, not quite!

The issue is that entry 1212 has two elements and 1213 three. So, these are not assigned based on the 'parent entry' but are all repeated for both entries.

Maybe that helps, take a look at the dMC directly that digest the relevant information