思考狮身人面像血统搜索(Thinking sphinx ancestry searching)

 我需要从包括子组的组中获取所有用户： 
 
 应用程序/索引/ user_index.rb 
 
 ThinkingSphinx::Index.define :user, with: :active_record, delta: ThinkingSphinx::Deltas::SidekiqDelta do
   has groups.id
   has "CONCAT_WS('/',groups.id,groups.ancestry)", as: :group_ids, type: :integer, multi: true
end
 
 但是当我试图搜索时： 
 
User.search_for_ids(with_all: { group_ids: [3] })
 
 它返回子组中的所有用户，但没有来自ID为3的组的用户 
 
 
 
 Sphinx 2.1.7运行undex arch linux 
 
 
 思考斯芬克斯v3.1.1 
 

I need to get all of the users from groups including subgroups:
 
app/indices/user_index.rb
 
 ThinkingSphinx::Index.define :user, with: :active_record, delta: ThinkingSphinx::Deltas::SidekiqDelta do
   has groups.id
   has "CONCAT_WS('/',groups.id,groups.ancestry)", as: :group_ids, type: :integer, multi: true
end
 
But when i'm trying to search:
 
User.search_for_ids(with_all: { group_ids: [3] })
 
It returns all of the users from subgroups, but without users from group with id 3
 
 
 
Sphinx 2.1.7 running undex arch linux
 
 
Thinking sphinx v3.1.1
 

原文：https://stackoverflow.com/questions/28449320