Generic iteration (*) select on object inside array insine another array doesn't work

SQL++
1

I tried this querry :
SELECT customerId, canalName, consto[*].linkedContact FROM Subquery as TEMPO;

Subquery works fine and send me this:

[
  {
    "canalName": [
      "coursesUCom",
      "MagasinPhysique",
      "magasinUCom"
    ],
    "consto": [
      [
        {
          "CNILFlag": false,
          "alias": false,
          "contactStatus": "active",
          "functionalUsed": [
            "secondaryPhone"
          ],
          "lastEmailContactDate": null,
          "lastMailContactDate": null,
          "lastSMSContactDate": null,
          "linkedContact": "000000028",
          "notValidated": false,
          "rejectMail": false,
          "transferSlice": null,
          "type": "Phone"
        }
      ],
      [
        {
          "CNILFlag": false,
          "alias": false,
          "contactStatus": "active",
          "functionalUsed": [
            "mainPhone"
          ],
          "lastEmailContactDate": null,
          "lastMailContactDate": null,
          "lastSMSContactDate": null,
          "linkedContact": "000000027",
          "notValidated": false,
          "rejectMail": false,
          "transferSlice": null,
          "type": "Phone"
        }
      ],
      []
    ],
    "customerId": "C00000007"
  },
  {
    "canalName": [
      "MagasinPhysique"
    ],
    "consto": [
      [
        {
          "CNILFlag": false,
          "alias": false,
          "contactStatus": null,
          "functionalUsed": [],
          "lastEmailContactDate": null,
          "lastMailContactDate": null,
          "lastSMSContactDate": null,
          "linkedContact": "000000001",
          "notValidated": false,
          "rejectMail": false,
          "transferSlice": null,
          "type": "Card"
        }
      ]
    ],
    "customerId": "C00000008"
  }
]

But it does’t work as expected. It gave me a result without any linkedContact!

2

consto has double ARRAY you should fix in your subquery or

SELECT customerId, canalName, ARRAY_FLATTEN(consto,2)[*].linkedContact FROM Subquery as TEMPO;

3

Thk you very much for your reply i found this solution an hour before you send it. Thks again!