Search first word in a field using filterrific

Search first word in a field using filterrific

I am using filterrfic gem to search an organization in the database. The problem I am facing is when I am searching for an organization whose name starts with National then I get the list of all the organizations which have National in their name. All I want is that it should just search the first word of the name_of_organisation field.

I am using filterrfic gem to search an organization in the database. The problem I am facing is when I am searching for an organization whose name starts with National then I get the list of all the organizations which have National in their name. All I want is that it should just search the first word of the name_of_organisation field.

organisation.rb

def self.search(search)
    if search
        where('name_of_organisation LIKE ?', "%#{search}%")
    else
        all
    end
end


filterrific( available_filters: [ :search_query
] )

scope :search_query, lambda { |query| return nil if query.blank?

terms = query.downcase.split(/\s+/)

terms = terms.map { |e|
    (e.gsub('*', '%') + '%').gsub(/%+/, '%')
}

num_or_conds = 1
 where(
    terms.map { |term|
        "(LOWER(organisations.name_of_organisation) LIKE ?) 
    }.join(' AND '),
    *terms.map { |e| [e] * num_or_conds }.flatten
)

}

Currently it displays all the Organisation as below: National Social Service Society for National Serivce

But What I want is that it should only search first word of the name_of_organisation field and display just Nation Social Service

ruby-on-rails

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Explain Ruby on rails MVC

Our Ruby on Rails Training will provide you to learn about Rails and web applications development with realty. Our Ruby on Rails Course also includes live sessions.

Pros & Cons you must know before using Ruby on Rails for your startup

Click here, free ruby on rails course videos for you. It shows you best way to complete Ruby certification. OnlineITGuru guides you towards easy Web script

Ruby on Rails Performance Tuning

Synchronises Assets between Rails and S3. Contribute to AssetSync/asset_sync development by creating an account on GitHub.

DoubleRenderError in Ruby on Rails

How do I solve the DoubleRenderError by using before_action.To practice my rails skills, I decided to make a website about events. It is a website mainly between organizations, who hold an event and volunteers, who join the event. Among all the problems I encountered, I want to share the DoubleRenderError because it bothered me for a long time and how I solve the problem.

Live Updates in Ruby on Rails with ActionCable Feature

There are times when one as a Ruby on Rails developer wants to implement a real-time feature, like a chat application, and after digging a bit you find a framework's feature named ActionCable, sounds new and scary, right? Fear not, I'll try to explain it as simple as possible so that at the end of this article you'll feel comfortable with the subject.