MikaAK/ecto_shorts

How to express "not in" filter?

Closed this issue · 3 comments

dvv commented

Hi!

What is the inverse of Actions.all(Foo, bar: [1, 2, 3]) # select * from foos where (not bar = any([1, 2, 3]))?

TIA

MikaAK commented

Good question here, we actually don't have a way. I've added this in #43 so the syntax would follow other nots where we do

%{field: %{!=: [1, 2, 3]}}
dvv commented

Wonder when are you planning publishing it at hexdocs.pm?

MikaAK commented

2.4.0 has been released with new changes 🎉

  • 👍1