Rails: select array based on attribute

Question

In my rails app I need to find all where:

balance != nil or 0
pause != true

I tried this but it didn't work

@foo = Product.all
@foo = @foo.where( "pause != ?", true )
@foo = @foo.where( "balance != ?", 0 )
@foo = @foo.where( "balance != ?", nil )

When you say it doesn't work, what do you get? An error or an unexpected output? — Srikanth Venugopalan
– Srikanth Venugopalan, Commented Jan 4, 2014 at 2:31

Srikanth Venugopalan · Accepted Answer · 2014-01-04 03:06:52Z

2

I believe you are ending up with an implicit AND between all conditions. How about something like

@foo = Product.where("pause!=? AND (balance !=? OR balance is not null)", true, 0)

Edit: updated to check for is not null instead of comparison with null. Refer to the Active Record query interface here

answered Jan 4, 2014 at 2:33

9,0495 gold badges39 silver badges76 bronze badges

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

2 Comments

@muistooshort - didn't realize that. What would you recommend for null checks?

balance is not null, x = null and x != null are both false for all x.