Rails 3.2 Query Format Postgres

Question

Okay, at the moment I have the following in my model:

has_many :current_monitorings, :class_name => "Monitoring",
:conditions => proc { [ 'monitorings.created_at > ?', Time.now.midnight ] }

I want to add a condition to this that checks if the outlet is_active attribute is set to false. I tried doing it like this:

has_many :current_monitorings, :class_name => "Monitoring",
:conditions => proc { [ 'monitorings.created_at > ? AND outlet.is_active = ?', Time.now.midnight, 'false' ] }

However, this doesn't work. I'm probably being stupid, but any help is greatly appreciated!

Austin · Accepted Answer · 2012-03-29 20:55:19Z

2

In your sql, outlet.is_active should be outlets.is_active. Assuming is_active is a boolean field, just pass false and not "false":

Try this:

has_many :monitorings

def current_monitorings
  monitorings.joins(:outlets).where(
    'monitorings.created_at > ? AND outlets.is_active = ?',
    Time.now.midnight,
    false
  )
end

edited Mar 29, 2012 at 20:55

answered Mar 29, 2012 at 20:46

Austin

3,9003 gold badges25 silver badges26 bronze badges

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

3 Comments

Ammar Over a year ago

This leaves me with PG::Error: ERROR: missing FROM-clause entry for table "outlets"

Austin Over a year ago

It shouldn't. It only performs 1 query.

Ammar Over a year ago

How would I call this from a different model. I'm trying to call this on the user model. However, I need to use this in my dashboard_controller.rb

Collectives™ on Stack Overflow

Rails 3.2 Query Format Postgres

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related