Ruby on Rails: Advanced search

by

You can create a new controller called search.

Your search form:

<%= form_tag search_index_path, method: :get do %>
  <%= text_field_tag :project, params[:project] %>
  <%= text_field_tag :client, params[:client] %>
  <%= submit_tag "Search", name: nil %>
<% end %>

incude in your routes.rb:

get "search/index"

your search controller:

def index
  #store all the projects that match the name searched
  @projects = Project.where("name LIKE ? ", "%#{params[:project]}%")  
  #store all the clients that match the name searched    
  @clients = Client.where("name LIKE ? ", "%#{params[:client]}%")
end

Now you can play with @projects and @clients in the index view.

Just be careful, because these variables might became nil if there is no match for the search.

EDIT – I am assuming you have two models Project and Client – if you cannot create a new controller you can create the search action in your current controller.

def search
  #store all the projects that match the name searched
  @projects = Project.where("name LIKE ? ", "%#{params[:project]}%")  
  #store all the clients that match the name searched    
  @clients = Client.where("name LIKE ? ", "%#{params[:client]}%")
end

And than you can use the @projects and @clients in the search view.

If you are trying to display the results in somewhere else (for example index view), you can just move the above to the correct action.

 def index
  ....
  #store all the projects that match the name searched
  @projects = Project.where("name LIKE ? ", "%#{params[:project]}%")  
  #store all the clients that match the name searched    
  @clients = Client.where("name LIKE ? ", "%#{params[:client]}%")
end

EDIT 2 – OK, you are trying to search by a combination of fields in the same model:

You and change your search method to add these two fields:

def self.search(search_project, search_client) 
  return scoped unless search_project.present? || search_client.present?
  where(['project_name LIKE ? AND client LIKE ?', "%#{search_project}%", "%#{search_client}%"])
end

But please note the || will return scope if your search_project OR search_client are not present, you can change for AND (&&) if you prefer.

Also, the AND will return only if both match, I mean the combination of search… You can also change it to OR if you want.

Having the search form:

Your search form:

<%= form_tag search_index_path, method: :get do %>
  <%= text_field_tag :project, params[:project] %>
  <%= text_field_tag :client, params[:client] %>
  <%= submit_tag "Search", name: nil %>
<% end %>

Then your controller must send the combination to the model:

@project_search = Project.search(params[:project], params[:client]).all

I think it will solve the problem…

More Related Contents:

  1. Explain like I'm LITERALLY five…what does it mean to "format" a string? [closed]
  2. How to change default timezone for Active Record in Rails?
  3. How to avoid NoMethodError for missing elements in nested hashes, without repeated nil checks?
  4. Unable to install gem – Failed to build gem native extension – cannot load such file — mkmf (LoadError)
  5. TZInfo::DataSourceNotFound error starting Rails v4.1.0 server on Windows
  6. How to determine if one array contains all elements of another array
  7. Rails 5: ActiveRecord OR query
  8. How can I download a file from a URL and save it in Rails?
  9. What does “WARN Could not determine content-length of response body.” mean and how to I get rid of it?
  10. Getting the warning “Insecure world writable dir /home/chance ” in PATH, mode 040777 for rails and gem
  11. What is the best way to seed a database in Rails?
  12. Cannot install JSON gem in rails using windows
  13. ERROR: Failed to build gem native extension on Mavericks
  14. How does load differ from require in Ruby?
  15. Where is the Rails method that converts data from `datetime_select` into a DateTime object?
  16. Encoding Ruby on Rails code?
  17. AWS S3: The bucket you are attempting to access must be addressed using the specified endpoint
  18. How to use Active Support core extensions
  19. Purpose of “consider_all_requests_local” in config/environments/development.rb?
  20. What to use instead of `render :text` (and `render nothing: true`) in rails 5.1 and later?
  21. Rails 4.0 Strong Parameters nested attributes with a key that points to a hash
  22. Rails 3.1 limit user created objects
  23. Ruby on Rails Callback, what is difference between :before_save and :before_create?
  24. How to URL encode a string in Ruby
  25. What is the difference between Gemfile and Gemfile.lock in Ruby on Rails
  26. Parametrized get request in Ruby?
  27. Why is respond_with being removed from rails 4.2 into it’s own gem?
  28. Rails devise: user_signed_in? not working
  29. Customizing Devise error messages in Rails 3?
  30. Why does adding “sleep 1” in an after hook cause this Rspec/Capybara test to pass?

Leave a Comment