Re: How can I order my list based on a field in a different table?

1) The model Word does not have the votes field, you cannot order the field it's not possessed.

2) You have to build a relation between the models first, check the relationships from Django Doc https://docs.djangoproject.com/en/dev/topics/db/models/#relationships
 
On Friday, August 9, 2013 10:04:47 PM UTC+8, Pepsodent Cola wrote:

1.)

How can I order my list based on a field in a different table?

        return Word.objects.filter(direct_transl_word='')

The above I want to do something like this where the field ('-votes') is located at table Altword.

Nothing happens when I use this though, don't understand why?

        #return Word.objects.filter(direct_transl_word='').order_by('-votes')

2.)

My altword_list.html viewpage breaks whenever I try to use query for my other table Altword.

        #return Altword.objects.filter(rosword__direct_transl_word='')

        #return Altword.objects.filter(word__direct_transl_word='')

#_______________________________________________________________________________

AltwordlistView

class AltwordlistView(generic.DetailView):

    model = Word

    #model = Altword

    template_name = 'navi_polls/altword_list.html'

    context_object_name = 'poll'

    def get_queryset(self):

# Filter 5

        return Word.objects.filter(direct_transl_word='')

        #return Word.objects.filter(direct_transl_word='').order_by('-votes')

        #return Altword.objects.filter(rosword__direct_transl_word='')

        #return Altword.objects.filter(word__direct_transl_word='')

#_______________________________________________________________________________

Models

class Word(models.Model):

    rosword = models.CharField(max_length=200)

    direct_transl_word = models.CharField(max_length=120, blank=True, null=True)

    pub_date = models.DateTimeField('date published')

    def __unicode__(self):

        return self.rosword

#_______________________________________________________________________________

Models

class Altword(models.Model):

    rosword = models.ForeignKey(Word)

    alt_ros_word = models.CharField(max_length=200)

    alt_transl_word = models.CharField(max_length=200)

    articulate = models.CharField(max_length=200)

    votes = models.IntegerField(default=0)

    pub_date = models.DateTimeField('date published')

    def __unicode__(self):

        return self.alt_ros_word

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.