rails 3 not nil

Question

I'm trying to select all records that are not null from my table using where method

Click to copy

MyModel.where(:some_id => !nil) 

but it doesn't work, is there any other solution to do this?

Answer 1

You can do it using the Arel syntax (which has the bonus of being database independent):

Click to copy

MyModel.where(MyModel.arel_table['some_id'].not_eq(nil))

Answer 2

Use a string rather than a hash

Click to copy

MyModel.where("some_id is not null")