ActiveRecord IS NOT NULL sql finder

Question

The following finder prints out IS NULL.

User.where(:id =>nil) #=> []
User Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` IS NULL ORDER BY created_at DESC

But I couldn't find how to print out IS NOT NULL one?

Duplicate http://stackoverflow.com/questions/4252349/rail-3-where-condition-using-not-null — dee-see, Aug 06 '11 at 12:26
This question has your answer - http://stackoverflow.com/questions/4252349/rail-3-where-condition-using-not-null — ipr101, Aug 06 '11 at 12:26

score 26 · Answer 1 · edited Aug 06 '11 at 17:20

26

Try User.where("id IS NOT NULL")

This should do your job

edited Aug 06 '11 at 17:20

Dylan Markow

answered Aug 06 '11 at 12:27

Wizz

score 19 · Accepted Answer · answered Dec 23 '14 at 03:43

19

The simplest, idiomatic ActiveRecord solution:

User.where.not(id: nil)

answered Dec 23 '14 at 03:43

l3x

2

Note: Only works with 'rails >= v4.0.2'. See: http://apidock.com/rails/ActiveRecord/QueryMethods/WhereChain/not – morgents Apr 30 '15 at 12:20

score 5 · Answer 3 · edited Jun 09 '16 at 19:15

5

User.where.not(id: nil) will work for rails 4.

User.where("id IS NOT NULL") will work for older versions.

edited Jun 09 '16 at 19:15

Seth

answered Oct 01 '14 at 12:45

Michael Sommer

This is more or less the same as http://stackoverflow.com/a/27613775/38765 (though you answered first), and also doesn't work on Rails 3. – Andrew Grimm Dec 16 '15 at 00:40

score 0 · Answer 4 · answered Aug 23 '16 at 08:07

0

Rails 4

you can try this

User.where("id is not NULL")

Also if you are looking to exclude particular id and include nil values following will work

User.where("id is NULL or id != 'excluded_id'")

answered Aug 23 '16 at 08:07

error-404

4 Answers4