Elixir + Ecto: How to do WHERE NOT IN [array]?

Question

I am trying to look for all Users that don't have a certain string element in their match_history field. I took a guess with this:

matched_user = User |> where([u], ^device_id not in u.match_history) |> limit(1) |> VideoChat.Repo.one

But it seems to break at the not part. Is there a way to do this?

Answer 1

Try

User |> where([u], not ^device_id in u.match_history)