Skip to content

Instantly share code, notes, and snippets.

@acro5piano
Created January 29, 2017 05:48
Show Gist options
  • Save acro5piano/b5a8962fb85c57b4566da1db712ac475 to your computer and use it in GitHub Desktop.
Save acro5piano/b5a8962fb85c57b4566da1db712ac475 to your computer and use it in GitHub Desktop.
SELECT "users".* FROM "users"
WHERE ("users"."name" ILIKE '%山田%'
AND ("users"."email" ILIKE '%gmail.com%'
OR "users"."address" ILIKE '%東京都%'))
= search_form_for @q do |f|
= f.search_field :name_cont
= f.grouping_fields do |g|
= g.hidden_field :m, value: 'or'
= g.search_field :email_cont
= g.search_field :address_cont
def index
@q = User.search(params[:q]))
@q.build_grouping unless @q.groupings.any?
@users = @q.result
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment