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

Question

I am trying to find all User that do not have a specific string element in their match_history field. I suggested that:

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

But he seems to be breaking up into the not part. Is there any way to do this?

Answer 1

Try

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