ActsAsWildSearchable

This plugin allows you to search in your models on each of its attributes using wild cards. The default behavior is to chain the search parameters using “or” and wild cards in both sides. This behavior can be changed by adding the :clause=>“and” and the :left=>true or :right=>true parameters

GEM Location

gem 'act_as_wild_searchable', :git => 'http://github.com/canimus/acts_as_wild_searchable-0.0.1.gem'

Installation

bundle install

Tested Versions

  • Rails 3.2.3

Usage

Query Basics

  • the _like? method

    Consider that you model has the name attribute

    User.name_like? "John"

  • the chain capabilities

    To chain various queries just add another query after the usage of the like? method

    User.name_like?("John").where(:id => 1)

  • the multiple_search

    You can add as many clauses and by default will be added using an “or” clause

    User.name_like? "John","David", "Peter" # Produces where (name like ? or name like ? or name like ?, "%John%", "%David%", "%Peter%")

  • the left

    You can position the wild card with a hash addition to the call

    User.name_like? "John","David", :left => true # Produces where (name like ? or name like ?,  "%John", "%David")

  • the right

    You can position the wild card with a hash addition to the call

    User.name_like? "John","David", :right => true # Produces where (name like ? or name like ?,  "John%", "David%")

  • the clause

    You can change the default behavior for the wild card search by addint the clause hash

    User.name_like? "John","David", :clause => "and" # Produces where (name like ? and name like ?,  "%John%", "%David%")

General configuration options

You can configure the following attributes that will locate the wild card for your search

left              # false by default
right             # false by default
clause            # "or" by default