Ruby on rails - Where SQL method

Question

I want to get all the microposts where 'something' = true.

This code works fine

class UsersController < ApplicationController
  .
  .
  .
  def show
    @user = User.find(params[:id])
    @microposts = @user.microposts
    @titre = @user.nom
  end
end

But when I tried to make a where sql method this code doesn't work.

class UsersController < ApplicationController
      .
      .
      .
      def show
        @user = User.find(params[:id])
        @microposts = @user.microposts.where("something = 'true'")
        @titre = @user.nom
      end
    end

any idea ?

The problem may be that something is a boolean and not a string. — Mischa
– Mischa, Commented Aug 10, 2012 at 14:45

PinnyM · Accepted Answer · 2012-08-10 14:51:11Z

4

  def show
    @user = User.find(params[:id])
    @microposts = @user.microposts.where(something: true)
    @titre = @user.nom
 end

See here or here for more info on narrowing the query scope.

edited Aug 10, 2012 at 14:51

PinnyM

35.6k4 gold badges77 silver badges84 bronze badges

answered Aug 10, 2012 at 14:46

gabrielhilal

10.8k8 gold badges56 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

gabrielhilal Over a year ago

@user1560922 - if the problem is solved, please accept the answer. Thanks

Michael · Accepted Answer · 2012-08-10 14:41:58Z

2

Write like this:

Micropost.where(user_id: params[:id], something: true)

answered Aug 10, 2012 at 14:41

Michael

5489 silver badges30 bronze badges

3 Comments

user1560922 Over a year ago

yes but on my users model: "has_many :microposts" will be useless then ?

Michael Over a year ago

What is the difference? Maybe it will be needed elsewhere.

Mischa Over a year ago

Changing to something: true is a good suggestion, but there is no reason not to use @user.microposts.

Collectives™ on Stack Overflow

Ruby on rails - Where SQL method

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related