# Group by?

**URL:** <https://www.ruby-forum.com/t/group-by/103873>\
**Category:** Rails\
**Created:** [May 11, 2007, 5:36am UTC](https://www.ruby-forum.com/t/group-by/103873 "2007-05-11T05:36:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rosoft2001](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/94ad74/32.png) [@rosoft2001](https://www.ruby-forum.com/u/rosoft2001)\
**Post date:** [May 11, 2007, 5:36am UTC](https://www.ruby-forum.com/t/group-by/103873/1 "2007-05-11T05:36:05Z")

</div>

How can you add an “group by title” clause to:

@books\_pages, @books = paginate (:books, :conditions =\> [‘keyid = ?’,  
@key.id], :order =\> ‘id DESC’, :per\_page =\> 10 )

Thanks

---

<div class="post-metadata">

**Author:** ![rosoft2001](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/94ad74/32.png) [@rosoft2001](https://www.ruby-forum.com/u/rosoft2001)\
**Post date:** [May 11, 2007, 7:36am UTC](https://www.ruby-forum.com/t/group-by/103873/2 "2007-05-11T07:36:24Z")

</div>

Hey there mate,

Go to [railscast.com](http://railscast.com) i think there is a quick 4 min viedo on it, that  
should help

---

<div class="post-metadata">

**Author:** ![rosoft2001](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/94ad74/32.png) [@rosoft2001](https://www.ruby-forum.com/u/rosoft2001)\
**Post date:** [May 11, 2007, 12:39pm UTC](https://www.ruby-forum.com/t/group-by/103873/3 "2007-05-11T12:39:05Z")

</div>

You just sent him to a spam search page ☹

Correct url:

```
http://railscasts.com/episodes/29

```

## Alain R.

[blog.ravet.com/](http://blog.ravet.com/)

---

<div class="post-metadata">

**Author:** ![rosoft2001](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/94ad74/32.png) [@rosoft2001](https://www.ruby-forum.com/u/rosoft2001)\
**Post date:** [May 11, 2007, 11:44pm UTC](https://www.ruby-forum.com/t/group-by/103873/4 "2007-05-11T23:44:33Z")

</div>

If I am not mistaken, with pagination you should be able to use all  
the parameters that you would on a find. So you could use the :group  
option.

@books\_pages, @books = paginate (:books, :conditions =\> [‘keyid = ?’,  
@key.id], :order =\> ‘id DESC’, :per\_page =\> 10, :group =\> “title” )

Scott

---

<div class="post-metadata">

**Author:** ![rosoft2001](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/94ad74/32.png) [@rosoft2001](https://www.ruby-forum.com/u/rosoft2001)\
**Post date:** [May 12, 2007, 10:05am UTC](https://www.ruby-forum.com/t/group-by/103873/5 "2007-05-12T10:05:10Z")

</div>

> Correct url:
> 
> ```
> http://railscasts.com/episodes/29
> 
> ```

Just watched a few of the railscasts. Most productive 20 minutes I’ve  
spent  
in the past 2 weeks 🙂