通过具有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.services

Then run loop.

通过具有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.services

Then run loop.