[Arel]Building query, but can't get a proper output

12 views
Skip to first unread message

Jeroen van Ingen

unread,
Mar 13, 2012, 10:10:40 AM3/13/12
to rubyonra...@googlegroups.com
I have the following code:

advertisements_arel = Advertisement.order("advertisements.id
DESC").arel
@advertisements = (params[:website_id].present? ?
advertisements_arel.where(:website_id => params[:website_id]) :
advertisements_arel).to_a

It returns a struct Arel::SelectManager::Row data
But I'd like it to return an array of Advertisement objects (like it
would normally do) so I can iterate over it more easily. Anyone know how
to do that?

--
Posted via http://www.ruby-forum.com/.

Juan Pablo Avello

unread,
Mar 13, 2012, 10:38:04 AM3/13/12
to rubyonra...@googlegroups.com
If you remove the .arel you get an ActiveRecord::Relation which you can iterate as if it were an Array, plus you can keep appending .where(...) as in your code

Regards. 

Jeroen van Ingen

unread,
Mar 13, 2012, 10:48:24 AM3/13/12
to rubyonra...@googlegroups.com
Right... stupid me...

Thanks anyway ;)

Reply all
Reply to author
Forward
0 new messages