Filter results in ROR application (treebook)

You can use SQL. I'm running low on time right now so this won't be detailed.

In your controllers folder you can create a method, call it "search" that can be written to search through the database.

There's 3 rails methods: find_by_field: Find the first record in the specified data field that matches a value. find_all_by_field: Find all records in the specified data field that match a value. find_by_sql: Find records using a customized SQL statement.

I've only done this once through an online class so I'd have to play around with the code for treebook, but the search method will look something like:

def search
    pattern = params[:searchFor]
    pattern = "%" + pattern + "%"
    @reviews = Review.where("title like ?", pattern)
end

You'll have to change title in the @reviews line.

Then in your search form you'll need to set the for_tag

<%= form_tag :action => 'search' do %>
<label><font color="#663300" size="-1">Search for review:</font> </label>
<%= text_field_tag :searchFor %>
<%= submit_tag "Find" %>
<% end %>

This code will need to be changed for treebook. And there might be some pieces I'm missing since I'm in a hurry.

I'll try to follow up later tonight.

Thanks a lot for this!

This might help as well: Active Record Query Interface

Thanks Philipp that indeed in helpful