We have models like this
class User < ActiveRecord::Base
has_many :tenders, :select=>"tenders.id, tenders.name", :through=>:assignments, :group=>"tenders.id,
tenders.name", :source=>:assignable, :source_type=>'Tender'
end
class Tender < ActiveRecord::Base
named_scope :invited, :conditions => ["assignments.state IN (?)",["pending","requested"]]
end
class Assignment < ActiveRecord::Base
end
If i fetch tenders of a user like this User.find(1).tenders.invited, it works fine.
But if i fetch tenders using following way then it remove group by clause of sql.
opt = {}
opt[:invited] = true
User.find(1).tenders.search(opt)
Any help why is searchlogic removing 'group by' clause? We can't rely on 'User.find(1).tenders.invited' for fetching tenders because this is not simplified way to manage many named_scopes and other search operators.
We have models like this class User < ActiveRecord::Base has_many :tenders, :select=>"tenders.id, tenders.name", :through=>:assignments, :group=>"tenders.id,
tenders.name", :source=>:assignable, :source_type=>'Tender' end
class Tender < ActiveRecord::Base named_scope :invited, :conditions => ["assignments.state IN (?)",["pending","requested"]] end
class Assignment < ActiveRecord::Base end
If i fetch tenders of a user like this User.find(1).tenders.invited, it works fine. But if i fetch tenders using following way then it remove group by clause of sql. opt = {} opt[:invited] = true
User.find(1).tenders.search(opt)
Any help why is searchlogic removing 'group by' clause? We can't rely on 'User.find(1).tenders.invited' for fetching tenders because this is not simplified way to manage many named_scopes and other search operators.
Junaid.