Thanks for the quick replay. The problem is the clip duplication, when relaying on clip_set.count() and also in the admin site when you see raw duplication after filtering , it is not very reasonable :)
1. in order to change this behavior in the admin site I need to manipulate main.py and add distinct() somewhere? 2. I read everywhere that distinct() works really slow and you better avoid using it. what do you say? Thanks again, On Dec 22, 11:42 am, Dan Fairs <dan.fa...@gmail.com> wrote: > > Hi all! > > I have 2 models: Clip, Tag. > > class Clip(models.Model): > > name = models.CharField(max_length=80) > > tags = models.ManyToManyField(Tag, through = 'TagsToClips') > > > class Tag(models.Model): > > tagName = models.CharField(max_length=80, unique=True) > > > class TagsToClips(models.Model) > > clip = models.ForeignKey(Clip) > > tag = models.ForeignKey(Tag) > > start_frame = models.IntegerField() > > duration = models.IntegerField() > > Great! Do you actually have a problem then? ;) > > Joking aside, and taking a wild stab at what your problem is without any > actual code, I'd say the underlying JOIN is producing multiple rows, and you > probably need a distinct() call somewhere on your queryset. > > Then again, that might not be the problem at all, because you haven't said :) > > Cheers, > Dan > > -- > Dan Fairs | dan.fa...@gmail.com |www.fezconsulting.com -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
