# Search

**URL:** <https://www.ruby-forum.com/t/search/191478>\
**Category:** Rails\
**Created:** [July 13, 2010, 10:58am UTC](https://www.ruby-forum.com/t/search/191478 "2010-07-13T10:58:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![anat42000](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/7ea924/32.png) [@anat42000](https://www.ruby-forum.com/u/anat42000)\
**Post date:** [July 13, 2010, 10:58am UTC](https://www.ruby-forum.com/t/search/191478/1 "2010-07-13T10:58:26Z")

</div>

Hi,

I’ve implemented two boxes of research which correspond to two columns  
of my table. This solution works well:

In my index.html.erb:  
\<% form\_tag search\_intervenants\_path, :method =\> :get do %\>  
\<%= label\_tag “code” %\>  
\<%= text\_field\_tag “search[by\_code]”,  
params[:search].try(:  
[], :code) %\>  
\<%= label\_tag “id” %\>  
\<%= text\_field\_tag “search[by\_id]”,  
params[:search].try(:[], :id) %\>  
\<%= submit\_tag “Search” %\>  
\<% end %\>

In my controller:  
def search  
@intervenants = Intervenant.search(params[:search])  
render :index  
end

In my model:  
def self.search(params)  
params.keys.inject(scoped({})) do |found, k|  
params[k].blank? ? found : found.send(:"#{k}", params[k])  
end  
end  
scope :by\_code, lambda {|name| where(“intervenants.code LIKE ?”,  
“%#{name}%”)}  
scope :by\_id, lambda {|name| where(“intervenants.id LIKE ?”,  
“%#{name}%”)}

I would like to have an only search area, I tried but I didn’t suceed  
in it… Who can help me? Thanks a lot !
