Remove array and retrieve the object [NotifiSuppAlertList ] value

SQL++
1

i am getting response in the array but i only want my response object how i can build my qurey.

SELECT ARRAY token FOR token IN t.notifiSupprRecords
WHEN token.category = “SH” AND token.type=“01”
END as NotifiSuppAlertList
FROM SUP_PREF_INT t
WHERE t.selectorValue=“0000287287”
AND ANY v IN notifiSupprRecords SATISFIES v.category=“SH” AND v.type=“01”
END

[
{
“NotifiSuppAlertList”: [
{
“accNum”: “0000287287”,
“category”: “SH”,
“type”: “01”

  },
  {
    "accNum": "0000287287",
    "acyGuuid": "fa34552d-8f1e-4a25-bf91-91338d193ck0",
    "type": "01"
   
  }
]

}
]

2

Use UNNEST

SELECT r AS  Alert
FROM SUP_PREF_INT AS t
UNNEST t.notifiSupprRecords AS r
WHERE t.selectorValue="0000287287"
AND r.category="SH" AND r.type="01";