通过具有has_and_belongs_to_many关系的子记录筛选/范围(Filter/scope by child records with has_and_belongs_to_many relationship)
我有一个与Languages模型有has_and_belongs_to_many关系的模型Service 。
我想获得具有给定语言的所有服务的范围。
我已经尝试了Service.joins(:languages).where(:languages => Language.find(1))但得到Mysql2::Error: Unknown column 'services.language_id'作为其使用第3个表来创建关联。
现在我卡住,任何指针请好人?
I have a model Service with has_and_belongs_to_manyrelationship to a Languages model.
I would like to get a scope of all the services that have a given language.
I have tried Service.joins(:languages).where(:languages => Language.find(1)) but get Mysql2::Error: Unknown column 'services.language_id'as its using a 3rd table to create the association.
Now im stuck, any pointers please wonderful people?
最满意答案
这一定是答案
@language = Language.find_by_id(1) @services = @language.services然后运行循环。
This must be the answer
@language = Language.find_by_id(1) @services = @language.servicesThen run loop.
更多推荐
发布评论