11 replies

Full text search on a given field in ash expression?

I have a table, which emits the map like

%{question_text: "filter keyword that should exist"}

%{question_text: "filter keyword that should exist"}

%{question_text: "filter keyword that should exist"}

%{question_text: "filter keyword that should exist"}

I am composing queries like

filter_expr  = Ash.Expr.expr(contains(^key , ^value))
Question
      |> Ash.Query.sort(sort)
      |> Ash.Query.filter(filter_expr)
      |> Ash.read!(

filter_expr  = Ash.Expr.expr(contains(^key , ^value))
Question
      |> Ash.Query.sort(sort)
      |> Ash.Query.filter(filter_expr)
      |> Ash.read!(

filter_expr  = Ash.Expr.expr(contains(^key , ^value))
Question
      |> Ash.Query.sort(sort)
      |> Ash.Query.filter(filter_expr)
      |> Ash.read!(

filter_expr  = Ash.Expr.expr(contains(^key , ^value))
Question
      |> Ash.Query.sort(sort)
      |> Ash.Query.filter(filter_expr)
      |> Ash.read!(

Here are other things I have tried.

filter_expr  = Ash.Expr.expr(contains(^key , ^value))
filter_expr = Ash.Expr.expr(fragment("? ILIKE ?", ^key, ^"%#{value}%"))

filter_expr  = Ash.Expr.expr(contains(^key , ^value))
filter_expr = Ash.Expr.expr(fragment("? ILIKE ?", ^key, ^"%#{value}%"))

filter_expr  = Ash.Expr.expr(contains(^key , ^value))
filter_expr = Ash.Expr.expr(fragment("? ILIKE ?", ^key, ^"%#{value}%"))

filter_expr  = Ash.Expr.expr(contains(^key , ^value))
filter_expr = Ash.Expr.expr(fragment("? ILIKE ?", ^key, ^"%#{value}%"))

I need a simple ilike style stuff for now.

Full text search on a given field in ash expression?

Similar Threads

Similar Threads

Similar Threads