I have tried and I think I have it mostly working: it returns ALL unique docid's.
What is left is that my code is part of a search function. Originally I got normalized keywords from a user and used those Q-objects to look for keywords in a selected set of columns. I still have to figure out how to get that into the SQL part.. On Jul 12, 3:29 pm, bruno desthuilliers <bruno.desthuilli...@gmail.com> wrote: > On Jul 12, 12:26 pm, Michel30 <forerunn...@gmail.com> wrote: > > > Hi guys, > > > I've been trying your suggestions but I'm afraid I'm stretching the > > limits of my Python/Django abilities ;-) > > > Bruno got it right: what I want is a queryset of "model" with distinct > > docid having the highest version number, sorted by revisiondate. > > (snip) > > My code does this, but the loop that selects the distinct docid's is > > what makes it terribly slow... > > Then why don't you just try the solution(s) I posted ? -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@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.
