Jim's got the right approach. You need to add a country_id column to tags and then store the country there. Another option would be to store the country_id on the taggings table, which would allow you to look up tags that have been used on taggings in a particular country. That way one tag could be used for multiple countries.
On Thu, May 6, 2010 at 10:55 PM, Jim Ruther Nill <[email protected]> wrote: > I don't think that can be done unless you edit the tags table, adding a > country_id in it. Once you have a country_id, you can now filter the tags > by country. To set the country, get the tagged object which usually has the > user_id attribute, get the user, then get the country. you can this in a > before_save callback. > > > On Fri, May 7, 2010 at 3:25 AM, sSs <[email protected]> wrote: > >> Hi, >> I've been looking at how we can display only tags in CE that were >> created by users in a specific country i.e. US. I was trying to see >> how I can do that using the current architecture, but there isn't an >> easy way such as the tags db table to be linked to the users db >> table. >> >> Does anyone know how tags can be retrieved only for a specific >> country, so that users in Canada don't see tags created by users in >> US. >> >> Thanks, >> SS >> >> -- >> You received this message because you are subscribed to the Google Groups >> "CommunityEngine" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<communityengine%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/communityengine?hl=en. >> >> > -- > You received this message because you are subscribed to the Google Groups > "CommunityEngine" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<communityengine%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/communityengine?hl=en. > -- You received this message because you are subscribed to the Google Groups "CommunityEngine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/communityengine?hl=en.
