rails whereの複数の値での検索について

Question

###前提・実現したいこと
railsのwhereの複数の値で検索させたいです。

###ソースコード
↓DBのXxxxxのカラムstatusからstatus: 30とstatus: 40両方取得してviewに渡したいと考えております。

  def xxxxx

    @xxxxx = Xxxxx.where(status: 30)
  end

status: 30だけですと上記でいいのですが、同時にstatus: 40も取得したいと考えているのですがどうすればいいのかなと。。。

宜しくお願いします。

Answer 1

次の例をご覧ください。
SQL の in や between を発行させることが可能です。

$ rails c
Running via Spring preloader in process 2328
Loading development environment (Rails 4.2.5)

Frame number: 0/20
[1] pry(main)> Order.all
  Order Load (28.9ms)  SELECT "orders".* FROM "orders"  ORDER BY ordered_at DESC
+----+-----------+----------+-------+-------------------------+-------------------------+-------------------------+
| id | client_id | status   | price | ordered_at              | created_at              | updated_at              |
+----+-----------+----------+-------+-------------------------+-------------------------+-------------------------+
| 2  | 1         | active   | 200   | 2000-01-01 21:28:42 UTC | 2015-12-27 02:28:42 UTC | 2015-12-27 02:28:42 UTC |
| 5  | 2         | payed    | 210   | 2000-01-01 21:28:42 UTC | 2015-12-27 02:28:42 UTC | 2015-12-27 02:28:42 UTC |
| 1  | 1         | received | 100   | 2000-01-01 02:28:42 UTC | 2015-12-27 02:28:42 UTC | 2015-12-27 02:28:42 UTC |
| 3  | 1         | payed    | 400   | 2000-01-01 02:28:42 UTC | 2015-12-27 02:28:42 UTC | 2015-12-27 02:28:42 UTC |
| 4  | 2         | payed    | 110   | 2000-01-01 02:28:42 UTC | 2015-12-27 02:28:42 UTC | 2015-12-27 02:28:42 UTC |
| 6  | 2         | payed    | 410   | 2000-01-01 02:28:42 UTC | 2015-12-27 02:28:42 UTC | 2015-12-27 02:28:42 UTC |
+----+-----------+----------+-------+-------------------------+-------------------------+-------------------------+
6 rows in set

[2] pry(main)> Order.where(price: [100,400])
  Order Load (0.2ms)  SELECT "orders".* FROM "orders" WHERE "orders"."price" IN (100, 400)  ORDER BY ordered_at DESC
+----+-----------+----------+-------+-------------------------+-------------------------+-------------------------+
| id | client_id | status   | price | ordered_at              | created_at              | updated_at              |
+----+-----------+----------+-------+-------------------------+-------------------------+-------------------------+
| 1  | 1         | received | 100   | 2000-01-01 02:28:42 UTC | 2015-12-27 02:28:42 UTC | 2015-12-27 02:28:42 UTC |
| 3  | 1         | payed    | 400   | 2000-01-01 02:28:42 UTC | 2015-12-27 02:28:42 UTC | 2015-12-27 02:28:42 UTC |
+----+-----------+----------+-------+-------------------------+-------------------------+-------------------------+
2 rows in set

[3] pry(main)> Order.where(price: [100..200])
  Order Load (0.2ms)  SELECT "orders".* FROM "orders" WHERE ("orders"."price" BETWEEN 100 AND 200)  ORDER BY ordered_at DESC
+----+-----------+----------+-------+-------------------------+-------------------------+-------------------------+
| id | client_id | status   | price | ordered_at              | created_at              | updated_at              |
+----+-----------+----------+-------+-------------------------+-------------------------+-------------------------+
| 2  | 1         | active   | 200   | 2000-01-01 21:28:42 UTC | 2015-12-27 02:28:42 UTC | 2015-12-27 02:28:42 UTC |
| 1  | 1         | received | 100   | 2000-01-01 02:28:42 UTC | 2015-12-27 02:28:42 UTC | 2015-12-27 02:28:42 UTC |
| 4  | 2         | payed    | 110   | 2000-01-01 02:28:42 UTC | 2015-12-27 02:28:42 UTC | 2015-12-27 02:28:42 UTC |
+----+-----------+----------+-------+-------------------------+-------------------------+-------------------------+
3 rows in set

Comments

[Mkato]

ご回答有難う御座います。

```
Order.where(price: [100,400])
```

この書き方いいですね。コード短く、内容も分かりやすいです。
さっそく実装させて頂きました。

いつも本当に有難う御座います。

Answer 2

Arelを使ってor条件をつけてあげれば良いかと思います。

x_table = Xxxxx.arel_table
@xxxxx = Xxxxx.where(x_table[:status].eq(30).or(x_table[:status].eq(40))

Arelを使いこなせば、複雑なSQLを発行できるようになりますよ

Comments

[Mkato]

ご回答有難う御座います。
頂いた方法で解決しました。初めてArelを知りましたので大変勉強になりました。

本当に有難う御座います。