Python Django jquery

Question

Before in my models.py I had

report_division = models.TextField(blank=True, max_length=40)

and I counted by filter using this line in my views.py:

CRS = Post.objects.filter(report_division='Something').count()

Now I have a seperate class in my models.py

class Divizija(models.Model):
    naziv_divizija = models.CharField(max_length=40)

    def __str__(self):
        return self.naziv_divizija

class Post(models.Model):
     report_division = models.ForeignKey(Divizija, on_delete=models.SET_NULL, null=True, 
     verbose_name="Divizija")

I can't get my query to work now. I tried:

CRS = Post.objects.filter(report_division=1).count()
CRS = Post.objects.filter(report_division_id=1).count()
CRS = Post.objects.filter(report_division='Something').count()

second one should work Post.objects.filter(report_division_id=1).count() what do you mean by not working is it giving you an error or is it not giving you the correct count? — aberkb
– aberkb, Commented Nov 9, 2021 at 17:30
It's working, donno why I didn't at start, maybe my mistake. Thank you for your reply. — MarkoZg
– MarkoZg, Commented Nov 9, 2021 at 17:37

Bruno Urbano · Accepted Answer · 2021-11-09 17:33:28Z

1

You have to specify the field of the foreign key you want to filter by

CRS = Post.objects.filter(report_division__naziv_divizija=1).count()
CRS = Post.objects.filter(report_division_id=1).count()  # this one is right
CRS = Post.objects.filter(report_division__naziv_divizija='Something').count()

answered Nov 9, 2021 at 17:33

Bruno Urbano

3772 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python Django jquery

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related