RailsFan Radha wrote:
>
> I have a table called category and i want to show only the records where
> "status = A" in my list.erb
>
> currently, my list.erb shows all records from category table.
> but, i would like to show only the records where status = 'A'
>
> for example:
> select * frm category where status = 'A'
>
> the idea behind this is, i have this status column to show only the
> active records.
> This status flag accepts,
> "A" for active,
> "I" for inative and
> "R" for "Requested newly, but not yet processed".
> .. and may be others as per the futurre needs.
>
> so how can i apply this filter of where status = 'A' in my controller.
>
> def list
> @categories=Category.find_all_categories
> end
>
>
>
> - thanks,
> radha
Added another method to the model,
def self.find_active_categories
find_by_sql("SELECT * from category
where status = 'A')
order by category_id ")
end
And changed the controller, list action to call this new method.
def list
@categories=Category.find_active_categories
end
And this seems to be working.
Let me know if i have missed any or please add any additional info which
this implies too.
- thanks,
radha.
--
Posted via http://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
