My project is enabling the user to write a post and every post have a category and every category have a supervisor, so I faced a problem I can’t get all posts for the specific category of specific supervisor.
My models
class PostCategory(models.Model):
name = models.CharField(max_length=150, null=True)
description = models.CharField(max_length=100, null=True)
def __str__(self):
return self.name
class UserSupervisorSpecialist(models.Model):
user = models.ForeignKey(User, related_name="user_id", on_delete=models.SET_NULL, null=True)
category = models.OneToOneField(CategoryPost, related_name="category_id", on_delete=models.SET_NULL, null=True)
def __str__(self):
return self.user.username
class Post(models.Model):
title = models.CharField(max_length=100, null=True)
content = RichTextField()
post_category = models.ManyToManyField(CategoryPost)
author = models.ForeignKey(User, on_delete=models.SET_NULL, null=True)
date_create = models.DateTimeField(auto_now_add=True, null=True)
status = models.BooleanField(default=False) #0 -> suspend
likes = models.IntegerField(default=0) #0 -> No like yet
supervisor = models.ForeignKey(UserSupervisorSpecialist, on_delete=models.SET_NULL, null=True)
def __str__(self):
return self.title
def snippet(self):
return self.content[:150]
My views:
def control_spanle(request):
category = UserSupervisorSpecialist.objects.filter(user=request.user)
post_filter = Post.objects.filter(supervisor=request.user.username)
return render(request, 'supervisor/controle_panel.html',{'Category':category,'post_filter':post_filter})