Hello,
Somehow I just can't seem to organise this in my head. So far I have three tables/models.
Group id
GroupCategory id, name
GroupCategoryValue group_category_id group_id value
So a group has many group_category_values which hold values for the categories which the group is associated with.
What I want to do is:
Find all groups which, given an hash of (group_category_id's and values) have every group_category and every value.
For example
Group
(:id => 1, :name => Iain's group) (:id => 2, :name => Another group)
GroupCategories (:id => 1, :name => Category1) (:id => 2, :name => Category2) (:id => 3, :name => Category3)
GroupCategoryValues (:group_id => 1, :group_category_id => 1, :value => "hello") (:group_id => 1, :group_category_id => 2, :value => "my") (:group_id => 1, :group_category_id => 3, :value => "world")
(:group_id => 2, :group_category_id => 1, :value => "hello") (:group_id => 2, :group_category_id => 2, :value => "my") (:group_id => 2, :group_category_id => 3, :value => "mum")
So if I gave the method {1 => "hello", 2 => "my"} both groups 1 and 2 should be returned but if I gave the method {1 => "hello", 2 => "my", 3 => "mum"} only group 2 should be returned.
Any ideas how to do this nicely? I tried using several methods and just got confused.
Also, the reason I want to do it in an sql/find way is because the resulting groups need paginating with the will_paginate plugin?
hope you can help
Iain