groups-search.ex

def list_groups(region \\ nil, search \\ nil) do
  query =
    from(g in Group)
    |> filter_region(region)
    |> add_rank(region)
    |> search(search)

  query |> Repo.all()
end

defp search(query, nil), do: query

# Make sure to use a subquery to we don't lose the correct ordering
defp search(query, search) do
  from(g in subquery(query), where: ilike(g.name, ^"%#{search}%"))
end