How to filter documents in a collection when inside an array in Arangodb?

Question

I am going through the tutorial on Arangodb which is using a sample game of thrones dataset. I am trying to figure out how I would be able to filter out characters based on a trait?

 INSERT {
    "name": "Ned",
    "surname": "Stark",
    "alive": true,
    "age": 41,
    "traits": ["A","H","C","N","P"]
} INTO Characters

I am trying to use the following code but its not working. Would the above traits be an array. if so how do I proceed?

for c in Characters
Filter c.traits =="A"
RETURN c

Thank you!

mpoeter · Accepted Answer · 2021-01-02 17:09:55Z

1

If you want to find all characters that have trait "A" you can use FILTER "A" IN c.traits, i.e., the characters may also have other traits. If you want to find characters that have only trait "A" you can use FILTER c.trait == ["A"].

answered Jan 2, 2021 at 17:09

mpoeter

3,0411 gold badge9 silver badges18 bronze badges

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

2 Comments

ShyamR Over a year ago

Suppose I wanted to filter characters with A and M? FILTER "A" AND "M" in c.traits is giving me an error

mpoeter Over a year ago

You can use ALL IN - see arangodb.com/docs/stable/aql/…

Collectives™ on Stack Overflow

How to filter documents in a collection when inside an array in Arangodb?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related