fix filter

bluzky · Oct 22, 2020 · 5e8fca4 · 5e8fca4
1 parent cde7a85
commit 5e8fca4
Show file tree

Hide file tree

Showing 2 changed files with 6 additions and 2 deletions.
diff --git a/lib/filter.ex b/lib/filter.ex
@@ -78,7 +78,7 @@ defmodule Querie.Filter do
   end
 
   def filter(:is, {column, value}) do
-    filter(column, value)
+    dynamic([q], field(q, ^column) == ^value)
   end
 
   def filter(_op, {_column, nil}) do
@@ -120,6 +120,10 @@ defmodule Querie.Filter do
     dynamic([q], field(q, ^column) >= ^lower and field(q, ^column) <= ^upper)
   end
 
+  def filter(:has, {column, value}) do
+    dynamic([q], ^value in field(q, ^column))
+  end
+
   def filter(:contains, {column, value}) do
     dynamic([q], like(field(q, ^column), ^"%#{value}%"))
   end

diff --git a/lib/parser.ex b/lib/parser.ex
@@ -31,7 +31,7 @@ defmodule Querie.SchemaHelpers do
 end
 
 defmodule Querie.Parser do
-  @supported_ops ~w(lt gt ge le is ne in contains icontains between ibetween sort)
+  @supported_ops ~w(lt gt ge le is ne in contains icontains between ibetween sort has)
 
   @doc """
   Parse params and return