Rails 4 - Best way to perform an advanced search

Question

In a custom advanced search form, what is the best way to perform a query to filter results?

class UsersController < ApplicationController

  def index
    @users = User.all
  end

end

In many case we have different types of data, for example:

name will be a string, surname will be a string, age will be an integer

In my specific case, i have a form with some filters that user can or can not fill. How can i do a dynamic query?

score 0 · Answer 1 · answered Jun 03 '15 at 09:30

0

Try this

User.where("name = ? or surname = ? or age = ? ", params[:first_name], params[:lastname], params[:age])

answered Jun 03 '15 at 09:30

Sachin R

11,606
10
35
40

OP said, `user can or can not fill`. So can you expect `params[:first_name]` each time user submits a form? – Arslan Ali Jun 03 '15 at 09:35
try to use like that params[:first_name] || "" – Sachin R Jun 03 '15 at 09:44

score 0 · Accepted Answer · answered Jun 03 '15 at 09:41

0

In you controller do this:

class UsersController < ApplicationController

  def index
    @users = User.search params[:filter]
  end

end

Then in User model do:

class User < ActiveRecord::Base
  def self.search(options = {})
    users = User.all
    users = users.where(name: options[:name] ) if options[:name].present?
    users = users.where(first_name: options[:first_name] ) if options[:first_name].present?
    users = users.where(last_name: options[:last_name] ) if options[:last_name].present?
    users = users.where(age: options[:age] ) if options[:age].present?
    users
  end
end

answered Jun 03 '15 at 09:41

usmanali

2,028
2
27
38

1

you can use `concerns` for that purpose – usmanali Jun 03 '15 at 09:45
please follow this answer to use `concerns`: http://stackoverflow.com/questions/14541823/how-to-use-concerns-in-rails-4 – usmanali Jun 03 '15 at 09:54

Rails 4 - Best way to perform an advanced search

2 Answers2