I have a list of states ie [AL, NY, OH] and I want match each value in the list to the field in a where clause.
I’ve tried:
|> Query.where(s.state = String.contains(states))
|> Query.where(Enum.member(s.state, states))
but both of these return a is not a valid query expression
error.
Does documentation exist for the Query.[expression]
syntax? Everything in the ecto documentation I’ve seen structures it in the standard postgres syntax.