Using dynamic finders to specify NOT NULL

Question

I very often want to use dynamic finders to specify NOT NULL. So…

this works:

Widget.find_all_by_color('blue')

this works:

Widget.find_all_by_color(nil)

But how can I do

SELECT * FROM `widgets` WHERE `color` IS NOT NULL;

?

Answer 1

Try this:

Widget.all(:conditions => "color IS NOT NULL")