Description
The gem helps to create filters for Rails’ ActiveRecord in an old-fashion way. It makes your controller simpler and forms effortless.
Filtered alternatives and similar gems
Based on the "ORM/ODM Extensions" category.
Alternatively, view Filtered alternatives based on common mentions on social networks and blogs.
-
ActsAsTaggableOn
A tagging plugin for Rails applications that allows for custom tagging along dynamic contexts. -
ActiveRecord Import
A library for bulk insertion of data into your database using ActiveRecord. -
Audited
Audited (formerly acts_as_audited) is an ORM extension that logs all changes to your Rails models. -
PublicActivity
Easy activity tracking for models - similar to Github's Public Activity -
Awesome Nested Set
An awesome replacement for acts_as_nested_set and better_nested_set. -
Closure Tree
Easily and efficiently make your ActiveRecord models support hierarchies -
Enumerize
Enumerated attributes with I18n and ActiveRecord/Mongoid support -
Ruby JSON Schema Validator
Ruby JSON Schema Validator -
ActiveRecord Reputation System
An Active Record Reputation System for Rails -
Acts As Tennant
Easy multi-tenancy for Rails in a shared database setup. -
ActsAsParanoid
ActiveRecord plugin allowing you to hide and restore records without actually deleting them. -
dry-validation
Validation library with type-safe schemas and rules -
acts_as_follower
A Gem to add Follow functionality for models -
ActiveRecordExtended
Adds additional postgres functionality to an ActiveRecord / Rails application -
ranked-model
An acts_as_sortable/acts_as_list replacement built for Rails 4, 5 and 6 -
Acts As Commentable
The ActiveRecord acts_as_commentable plugin -
Rails PG Extras
Rails PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more. -
Acts As Commentable with Threading
Similar to acts_as_commentable; however, utilizes awesome_nested_set to provide threaded comments -
StoreModel
Work with JSON-backed attributes as ActiveRecord-ish models -
activerecord-multi-tenant
Rails/ActiveRecord support for distributed multi-tenant databases like Postgres+Citus -
ActsAsTree
ActsAsTree -- Extends ActiveRecord to add simple support for organizing items into parent–children relationships. -
mongoid-history
Multi-user non-linear history tracking, auditing, undo, redo for mongoid. -
ArLazyPreload
Lazy loading associations for the ActiveRecord models -
activerecord_json_validator
🔩 ActiveRecord::JSONValidator makes it easy to validate JSON attributes against a JSON schema. -
ActiveImporter
Define importers that load tabular data from spreadsheets or CSV files into any ActiveRecord-like ORM. -
arel-helpers
Useful tools to help construct database queries with ActiveRecord and Arel. -
Mongoid Tree
A tree structure for Mongoid documents using the materialized path pattern -
ActiveValidators
Collection of ActiveModel/ActiveRecord validators -
PermenantRecords
Rails Plugin - soft-delete your ActiveRecord records. It's like an explicit version of ActsAsParanoid -
mini_record
ActiveRecord meets DataMapper, with MiniRecord you are be able to write schema inside your models. -
data_miner
Download, unpack from a ZIP/TAR/GZ/BZ2 archive, parse, correct, convert units and import Google Spreadsheets, XLS, ODS, XML, CSV, HTML, etc. into your ActiveRecord models. Uses RemoteTable gem internally. -
Espinita
Audit activerecord models like a boss (and works with rails 4!)
Static code analysis for 29 languages.
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.
Do you think we are missing an alternative of Filtered or a related project?
README
Filtered - add filter to ActiveRecord queries
The gem helps to create filters for Rails’ ActiveRecord in an old-fashion way. It makes your controller simpler and forms effortless.
Installation
Add this line to your application's Gemfile:
gem "filtered"
And then run:
# 1. Download and install the gem
$ bundle
# 2. Generate a base filter class
$ rails generate filtered:install
create app/filters/application_filter.rb
Usage
To create a new filter with a generator:
$ rails generate filter car make model year body # fields can be added later
create app/filters/car_filter.rb
To use this filter in a controller:
# app/controllers/noise_measurements_controller.rb
class NoiseMeasurementsController < ApplicationController
before_action :set_filter
def index
@measurements = CarNoiseMeasurement.all.merge(@filter)
end
private
def set_filter
# it can take an optional block if you need to set an auxilary variable:
@filter = CarFilter.new(filter_params) do |f|
f.user = current_user
end
end
def filter_params
params.fetch(:filter, {}).permit(make: [], model: [], year: [], body: [], :ordering)
end
end
To define your filter:
# app/filters/car_filter.rb
class CarFilter < ApplicationFilter
attr_accessor :user
# Usage with default values.
# It will add a simple `.where(year: ["2010", "2011"])` clause to query.
field :year
# Or you can fully control how Filtered modifies query with a block.
# Notice that block returns lambda. That's because we want to postpone
# it's evaluation and let ActiveRecord do that when required.
# It will add `.joins(:specification).merge(Car::Specification.where(year: ["2010", "2011"]))`
# clause to the query.
field :year do |year|
-> { joins(:specification).merge(Car::Specification.where(year: year)) }
end
# There are some options to a filter field.
# `allow_nil` (default is false) will allow nil values to be passed into query.
# Defatul behaviour is to ignore field althogher if value is nil.
field :year, allow_nil: true
# `allow_blank` (default is false) will allow empty values to be passed into query.
# Defatul behaviour is to ignore field althogher if value is blank.
field :year, allow_blank: true
# `default` will set field default value if field is not passed into constructor.
# it accepts literal value:
field :year, default: "2019"
# method name
field :year, default: :default_year
# or lambda with filter object as argument
field :year, default: -> (filter) { filter.default_year }
# `if` and `unless` will switch filter on or off based on value or filter.
# it can accept lambda with value as argument:
field :year, if: -> (value) { %w(2018 2019).include?(value) }
# or value and filter as argument:
field :year, if: -> (value, filter) { filter.user.present? && %w(2018 2019).include?(value) }
# or method name. it will pass value as an argument
field :year, if: :year_applicable?
private
def default_year
if user
user.defaults.year
else
"2019"
end
end
def year_applicable?(value)
user.present? && %w(2018 2019).include?(value)
end
end
To use the same @filter
object in views (it will automatically set all the related inputs in a form):
# app/views/noise_measurements/index.slim
= form_for(@filter, url: search_path, method: "GET", as: :filter) do |f|
.fields
span Year
- YEARS.each do |year|
= year
= f.check_box :year, { multiple: true }, year, nil
.fields
span Body
- BODIES.each do |body|
= body
= f.check_box :body, { multiple: true }, body, nil
.fields
span Make
- MAKES.each do |make|
= make
= f.check_box :make, { multiple: true }, make, nil
.fields
span Sorting
span Year
= f.radio_button :ordering, "year asc"
= f.radio_button :ordering, "year desc"
span Idle
= f.radio_button :ordering, "noise_idle asc"
= f.radio_button :ordering, "noise_idle desc"
span 50
= f.radio_button :ordering, "noise_50 asc"
= f.radio_button :ordering, "noise_50 desc"
span 80
= f.radio_button :ordering, "noise_80 asc"
= f.radio_button :ordering, "noise_80 desc"
.actions
= f.submit "Filter"
Under the hood
Filtered uses API provided by ActiveRecord merge method. There are a few open issues in ActiveRecord related to that method, please, have a look through it here.
Ruby/Rails versions supported
Ruby: 2.3.x, 2.4.x, 2.5.x, 2.6.x, jruby-9.1.x, jruby-9.2.x. Rails: 4.0.x, 4.1.x, 4.2.x, 5.0.x, 5.1.x, 5.2.x, 6.0.0rc.
Credits
This gem woudn't exist without original ideas of @caJaeger.
Development
After checking out the repo, run bin/setup
to install dependencies. Then, run rake spec
to run the tests. You can also run bin/console
for an interactive prompt that will allow you to experiment.
To install this gem onto your local machine, run bundle exec rake install
. To release a new version, update the version number in version.rb
, and then run bundle exec rake release
, which will create a git tag for the version, push git commits and tags, and push the .gem
file to rubygems.org.
Contributing
Bug reports and pull requests are welcome on GitHub at https://github.com/dubadub/filtered. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the Contributor Covenant code of conduct.
License
The gem is available as open source under the terms of the MIT License.
Code of Conduct
Everyone interacting in the Filtered project’s codebases, issue trackers, chat rooms and mailing lists is expected to follow the code of conduct.
*Note that all licence references and agreements mentioned in the Filtered README section above
are relevant to that project's source code only.