如何组合Rails两个Scope，实现标准成员组标题搜索功能？

Hey there! Let's get this sorted out. The goal is to combine your two scopes so you can search for group titles and only return groups with "Standard" membership—right?

First, let's break down why your initial "AND" attempt might have failed: Rails scopes are designed to be chainable, so you don't need to manually write an AND clause. The issue probably came down to how you were trying to combine them, or the conditional check in by_group_title.

Solution 1: Chain Existing Scopes Directly #

The simplest way is to just chain your two scopes together. Since Rails automatically combines scope conditions with AND, this will do exactly what you want: filter groups by title (when a search term is present) and restrict results to "Standard" membership.

Here's how you'd use it in your controller or elsewhere:

# When you have a search term
@groups = Group.by_group_title(params[:group_search]).by_standard_membership

# Even if the search term is empty, this will still return only Standard groups
# because by_group_title will return all records (since group.present? is false)
# and then by_standard_membership filters them down

Solution 2: Create a Combined Scope (Cleaner for Reuse) #

If you find yourself using this combination often, creating a single dedicated scope makes your code more readable and maintainable. Here's how to define it:

scope :by_standard_group_title, -> (group) do
  base_scope = where(membership: "Standard")
  if group.present?
    base_scope.where('title LIKE ?', "%#{group}%")
  else
    base_scope
  end.order(created_at: :desc)
end

Then use it like this:

@groups = Group.by_standard_group_title(params[:group_search])

This scope handles both cases (search term present or not) and ensures you always get "Standard" membership groups.

Why Your Initial Attempt Might Have Failed #

Chances are you tried something like manually combining the SQL conditions instead of using Rails' chainable scopes. For example, if you wrote:

# This won't work correctly because it's not leveraging scope chaining
scope :combined, -> (group) { where('title LIKE ? AND membership = "Standard"', "%#{group}%") if group.present? }

This would fail when the search term is empty, and it's less flexible than chaining existing scopes.

Also, note that your original scopes use order(created_at: :desc) twice—when chaining, you only need the order once (though Rails will overwrite it if you include it in both, but it's cleaner to remove one or move it to the combined call).

Quick Note on Security #

Great job using parameterized queries (?) in your by_group_title scope—this protects you from SQL injection attacks. Never concatenate user input directly into SQL strings!

内容的提问来源于stack exchange，提问作者random_user_0891