So in the same way that you could do @items.active.first to get the first item, is there a way to select something else, like 56th?
Obviously @items.active.fiftysixth doesn't work, but is there some other method for accessing that?
Add a comment |
1 Answer
When the collection is a relation, you can use offset (.first just translates to limit 1 in SQL)
@items.active.offset(55).first Or, if it's an array:
@items.active[55] 
7 Comments
dbenhur
The 56th element is index 55. Ruby arrays start at 0.
fl00r
@items.active.offset(55).first. While @items.active[55] is very bad ideadbenhur
@fl00r it depends. If he only ever wants the 56th entry, then offset is preferred, if he wants many entries, or to traverse the collection based on some calculation he's probably better fetching the whole collection and indexing it as an array.
Perry Horwich
As an aside, do you think rails guarantees row order in a given table?
MrTheWalrus
@PerryHorwich I believe Rails simply puts them in whatever order the database returns them. If you specify an
.order, then they'll be in that order. Otherwise, there are no guarantees. |