arangodb AQL How to modify the value of the object in a nested array?

Question

I have document organized such way:

{
  "email": "[email protected]",
  "name": "tyler",
  "address": {
    "street": "Beijing Road",
    "zip": 510000
  },
  "likes": [
    "running",
    {
      "movie": "Star Wars"
    }
  ]
}

I have problem in modifying the value of "movie". Could you help me, how to modify the value with AQL?

Thanks!

stj · Accepted Answer · 2017-10-12 06:04:22Z

5

The following query should do. I put the explanation as comments inside the query. My example assumes the documents are present in a collection named collection:

FOR doc IN collection
  /* any filter condition to find the document(s) in question.
     you should make sure this uses an index if there is a substantial
     number of documents in the collection */
  FILTER doc.name == 'tyler' 

  /* enumerate the old likes and return them as is if they are not
     of type object or do not have a 'movie' attribute. If they are
     objects and have a 'movie' attribute, patch them with a 'movie'
     value of 'whatever' */
  LET newLikes = (
    FOR oldLike IN doc.likes 
      RETURN 
        (TYPENAME(oldLike) == 'object' && HAS(oldLike, 'movie')) ?
            { movie: 'whatever' } :
            oldLike
  ) 

  /* finally update the matching document(s) with the new likes */
  UPDATE doc WITH { likes: newLikes } IN collection

answered Oct 12, 2017 at 6:04

stj

9,11722 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tyler_li Over a year ago

Thank you very much for your detailed answer.

Collectives™ on Stack Overflow

arangodb AQL How to modify the value of the object in a nested array?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related