Numeric search using filterrific in rails

numeric_search_using_filterrific.txt

If you want to search every keyword including numbers with filterrific in rails, you can use the following search scope.

  scope :search_query, lambda { |query|
    return nil  if query.blank?
    terms = query.to_s.downcase.split(/\s+/)

    terms = terms.map { |e|
        ('%'+ e.gsub('*', '%') + '%').gsub(/%+/, '%')
    }
    # configure number of OR conditions for provision
    # of interpolation arguments. Adjust this if you
    # change the number of OR conditions.
    num_or_conds = 1
    where(
        terms.map { |term|
          "(LOWER(students.name) LIKE ?)"
        }.join(' AND '),
        *terms.map { |e| [e] * num_or_conds }.flatten
      )
  }