Add an element to nested array

SQL++
1

Hi Team,
This is a sample doc, and I want to use N1ql query to add another ip “10.0.0.3” to IPs array.

{
 "domain": "corporate.it",
 "user": [
      {
        "family": "Tiger",
        "given": "Scott",
        "login": "stiger",
        "machine": {
          "hostname": "Win2016-PC1",
          "maxConnections": "500",
          "IPs": [
            "10.0.0.1",
            "10.0.0.2"
          ]
        }  
      }
  ]    
}

Thanks,
Matthew

2 
UPDATE default AS d
SET u.machine.IPs = ARRAY_APPEND(u.machine.IPs, "10.0.0.3")
       FOR u IN d.`user` WHEN u.login = "stiger"  AND u.machine.hostname = "Win2016-PC1" END
WHERE d.domain = "corporate.it"
      AND ANY u IN d.`user` SATISFIES u.login = "stiger" AND u.machine.hostname = "Win2016-PC1" END;

Adjust conditions based on your need

3

It’s working.
Thanks!