The behavior of "where" when querrying for a null value is include the statment and return rows with null value.
This gem creates a simple way to remove statements with null/blank values from query.
Very usefull for search forms avoiding you to worry about unfilled fields.
Add this line to your application's Gemfile:
gem 'where_unless_blank'And then execute:
$ bundle
Or install it yourself as:
$ gem install where_unless_blank
After install this gem three new methods will be available on ActiveRecord::Base instances.
where_unless_blank, ilike_unless_blank and like_unless_blank.
Person.where_unless_blank(age: params[:age]).ilike_unless_blank(name: params[:name])
Person.ilike_unless_blank(name: params[:name], surname: params[:surname])
Person.like_unless_blank(name: params[:name], surname: params[:surname])
If u like short names u can use:
wub or where_ub for where_unless_blank
iub or ilike_ub for ilike_unless_blank
lub or like_ub for like_unless_blank
If all params are blank it will behaivor like all method.
Bug reports and pull requests are welcome on GitHub at https://github.com/platbr/where_unless_blank.