CODEWITHSUNDEEP
case-sensitivearangodbaql
skinneejoe
skinneejoe

Reputation: 3991

ArangoDB AQL Non Case Sensitive Comparison

Let's imagine I have a few simple docs stored in an Arango collection like so:

[
    {"type":Cat, "quality":Fuzzy}
    {"type":Dog, "quality":Barks}
    {"type":Rabbit, "quality":Hoppy}
    {"type":Pig, "quality":Chubby}
    {"type":Red Panda, "quality":Fuzzy}
    {"type":Monkey, "quality":Hairy}
]

Now let's say a user initiates a search in my application for all animals that are 'fuzzy', all lower case. Is there a way with AQL to make a comparison that is not case sensitive? So for instance:

FOR a IN animals
    FILTER a.type.toLowerCase() == fuzzy
    RETURN a

Now I know the above example doesn't work, but it would be nice if there was a way to do this. Thanks!

Upvotes: 8

Views: 2659

Answers (1)

yojimbo87
yojimbo87

Reputation: 68335

There is a LOWER string function in AQL which you can try to use in your query like this:

FOR a IN animals
    FILTER LOWER(a.quality) == 'fuzzy'
    RETURN a

Upvotes: 9

Related Questions