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

Thank you Eric for the pointers!

But I think Django is complaining about me having too many Relationships in table Altword, or perhaps I have typed syntax wrong and missunderstand the error message?

Exception Value:	<class 'navi_polls.models.Altword'> has more than 1 ForeignKey to <class 'navi_polls.models.Word'>

#_______________________________________________________________________________

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

#_______________________________________________________________________________

class Altword(models.Model):

#class Altword(Word):

    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)

    wordy = models.OneToOneField(Word, related_name='altword_wordy', primary_key=True)

    votes = models.IntegerField(default=0)

    pub_date = models.DateTimeField('date published')

    def __unicode__(self):

        return self.alt_ros_word

#_______________________________________________________________________________

First I tried to follow this example but then above error showed up:

https://docs.djangoproject.com/en/1.5/topics/db/examples/one_to_one/

Second time I tried this but I couldn't make it work:

http://catherinetenajeros.blogspot.se/2013/04/django-error-one-or-more-models-did-not.html

Third time I tried to play with "Multi-table inheritance".  But it only lead to Django complaining about duplicate fields which suggested that I needed to change field names in several files.  I didn't go down that path.  And it seemed "Multi-table inheritance" also complained about my first error message about having too many relationships in Altword table.

https://docs.djangoproject.com/en/1.0/topics/db/models/#id7

How should I proceed in order to find the solution to this problem?

On Saturday, August 10, 2013 10:32:37 AM UTC+2, Eric Cheung wrote:

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.