Unsetting only one array from the Nest

SQL++
1

Hello Team,

I would like to update the document to unset the record. I would like to delete the array which is have
“componentId”: 54300910,
“componentInstId”: 54101826,

Could you provide the update statement?

existing document

 "Bundles": [
    {
      "activeDt": "2021-02-01T16:00:00Z",
      "connectReason": 1,
      "offerId": 2000233447,
      "packageId": 1201226154,
      "packageInstId": 192670648,
      "packageInstIdServ": 3,
      "packageStatus": 1,
      "Bundles": [
        {
          "activeDt": "2021-03-14T21:25:50Z",
          "offerId": 2000226539,
          "Components": [
            {
              "activeDt": "2021-02-02T16:00:00Z",
              "characteristicValues": {
                "dummyAgInter": "0_AgInter"
              },
              "componentId": 54300910,
              "componentInstId": 54107886,
              "componentInstIdServ": 3,
              "componentStatus": 1,
              "connectReason": 1,
              "externalId": "54300910",
              "offerId": 2000214905,
              "packageId": 1201226154,
              "packageInstId": 192670648,
              "packageInstIdServ": 3,
              "productInstId": 54047557,
              "subscrNo": 14263305,
              "subscrNoResets": 0
            },
            {
              "activeDt": "2021-02-01T16:00:00Z",
              "characteristicValues": {
                "dummyAgInter": "0_AgInter"
              },
              "componentId": 54300910,
              "componentInstId": 54101826,
              "componentInstIdServ": 3,
              "componentStatus": 0,
              "connectReason": 1,
              "externalId": "54300910",
              "inactiveDt": "2021-10-25T00:00:00Z",
              "offerId": 2000214905,
              "packageId": 1201226154,
              "packageInstId": 192670648,
              "packageInstIdServ": 3,
              "productInstId": 54047559,
              "subscrNo": 14263305,
              "subscrNoResets": 0
            },
            {
              "activeDt": "2021-02-01T16:00:00Z",
              "characteristicValues": {
                "dummyAgInter": "0_AgInter"
              },
              "componentId": 1204661944,
              "componentInstId": 521292087,
              "componentInstIdServ": 3,
              "componentStatus": 1,
              "connectReason": 1,
              "externalId": "1204661944",
              "offerId": 2000215181,
              "packageId": 1201226154,
              "packageInstId": 192670648,
              "packageInstIdServ": 3,
              "productInstId": 54047562,
              "subscrNo": 14263305,
              "subscrNoResets": 0
            },

Regards
Dhaval.

2 
UPDATE mybucket AS d
SET b2.Bundles  = ARRAY c FOR c IN b2.Components 
                  WHEN  c.componentId IS NOT VALUED 
                                   OR c.componentInstId IS NOT VALUED  
                                   OR c.componentId != 54300910 
                                  OR c.componentInstId != 54107886 END
             FOR b2 IN b1.Bundles
                         FOR b1 IN d.Bundles 
WHERE ANY b1 IN d.Bundles 
           SATISFIES (ANY b2 IN b1Bundles  
                      SATISFIES (ANY c IN b2.Components 
                                 SATISFIES c.componentId = 54300910 AND c.componentInstId = 54107886 END) END) END;

If you need delete whole array instead of SET clause use following UNSET clause

UNSET b2.Components
       FOR b2 IN b1.Bundles
           FOR b1 IN d.Bundles WHEN ANY c IN b2.Components 
                                    SATISFIES c.componentId = 54300910 AND c.componentInstId = 54107886 END END