Rewriting this where using private fn

    term
    |> from t in Item

This isn’t a valid way to use from, it expands to from(term, t in Item) since |> puts arguments at the front.

What can I pipe it through?

When you’re using from you don’t pipe.

See this topic:

#keywords query syntax
import Ecto.Query
from u in “users”, where: u.age > 18, select: u.name

#pipe-based syntax
“users”
|> where([u], u.age > 18)
|> select([u], u.name)

This works

def list_items(%{matching: name}) when is_binary(name) do
    Item
    # |> where([m], ilike(m.name, ^"%#{name}%"))
    |> search(name)
    |> Repo.all()
  end

  defp search(query, name) do
    query = from(query in Item)

    query
    |> where([t], ilike(t.name, ^"%#{name}%"))
  end

But I get a dializer error with unused query variable. Is there a better way to do this?

You can’t pipe into from. The ecto docs contain examples of how to use pipe with where, you don’t need to use from.

I couldn’t think of another way that is why, I am asking.

I also read through the docs.

Hi , I kind of did this for my requirement. hope it helps you,

def search(params)
 qfilters       = reject_empty_values(params)
search_q =  profile_q(qfilters)
(from p in search_q , where: p.id == 2) |> Repo.all
end
defp profile_query([]), do: Profile
defp profile_query(filters) do
  from q in Profile, where: filters
end

Thanks but i am trying to keep the public fn clean and use only pipes there and do the actual work in private fn.

How about this

def search(model, %{name: name} = params) do
   model
   |> search_q(name)
   |> Repo.all
end

defp search_q(model, name) do
  from m in model, where: m.name == name
end

Interesting, I am now wondering if if can keep and do

def list_items(%{matching: name, query: query}) when is_binary(name) do
    Item
    # |> where([m], ilike(m.name, ^"%#{name}%"))
    |> search(name)
    |> Repo.all()
  end