Hello, I have encountered a specific issue that I am trying to address. I am developing a tasking system based on three models: the taskings model, the extended user model (profile), and the default User model in Django. My goal is to showcase the usernames of individuals assigned tasks through the sales_extras field, which is an extension of the User model.
Below are my models:
class Sales_taskings(models.Model):
sales_status= (
('p1','Phase 1'),
('p2','Phase 2'),
('p3','Phase 3'),
('p4','Phase 4'),
)
task_id = models.AutoField(primary_key=True)
sales_extras= models.ManyToManyField('sales.Sales_extras')
sales_project= models.ForeignKey('sales.Sales_project',on_delete=models.CASCADE)
description = models.TextField(max_length=200 , default='your notes' )
date_time = models.DateTimeField(auto_now=True)
status = models.TextField(max_length=10, choices= sales_status ,default='p1')
class Sales_extras(models.Model):
role= (
('sm','sales_manager'),
('s','sales'),
)
user = models.OneToOneField(User,on_delete=models.CASCADE)
user_type = models.TextField(max_length=500, choices= role)
Here is my view with context:
@login_required
def sales_taskboard(request):
authentication_classes = [SessionAuthentication, BasicAuthentication]
permission_classes = [IsAuthenticated]
sales_extras_id = Sales_taskings.objects.values('sales_extras').get('username')
print(Sales_taskings.objects.values('sales_extras'))
usernames = User.objects.values('username').filter(id__in=sales_extras_id)
print(usernames)
context = {
'sales_task': Sales_taskings.objects.all(),
'sales_extras': Sales_taskings.objects.values('sales_extras'),
'usernames': usernames
}
return render(request, 'sales/taskboard.html',context)
As I am new to Django, the above represents my attempts at extracting usernames. I believe there should be a predefined query method that would allow me to establish a connection between my sales_takings model, sales_extras model, and ultimately the User model.
Your assistance in this matter would be greatly appreciated!