From 53c26fcaee58e15eb4f11ce250c09a3015e0e1a1 Mon Sep 17 00:00:00 2001 From: Zachary Scott Date: Sun, 1 Jun 2014 13:56:09 -0700 Subject: Remove docs regarding grouping multiple values, as we should avoid duplicating API reference in guides. Also :scissors: [ci skip] --- guides/source/active_record_querying.md | 19 +------------------ 1 file changed, 1 insertion(+), 18 deletions(-) (limited to 'guides') diff --git a/guides/source/active_record_querying.md b/guides/source/active_record_querying.md index b2d71d4be8..673dcfc1d3 100644 --- a/guides/source/active_record_querying.md +++ b/guides/source/active_record_querying.md @@ -665,7 +665,7 @@ To get the total of grouped items on a single query call `count` after the `grou ```ruby Order.group(:status).count -# => { 'awaiting_approval' => 7, 'paid' => 12 } +# => { 'awaiting_approval' => 7, 'paid' => 12 } ``` The SQL that would be executed would be something like this: @@ -676,23 +676,6 @@ FROM "orders" GROUP BY status ``` -It is possible to do this count with multiple values, to do this only add the -other column to `group`. - -```ruby -Order.group(:status, :delivery_method).count -# => { ['awaiting_approval', 'regular'] => 5, ['awaiting_approval', 'fast'] => 2, ['paid', 'regular'] => 2, ['paid', 'fast'] => 10 } -``` - -The SQL that would be executed would be something like this: - -```sql -SELECT COUNT (*) AS count_all, status AS status, -delivery_method AS delivery_method -FROM "orders" -GROUP BY status, delivery_method -``` - Having ------ -- cgit v1.2.3