如何通过外键返回数组中的整个表行，以及如何从Django模型中的模板进行访问

Question

我试过这样做。但它返回的是唯一一个组合值

class Employees(models.Model):
    nameininitials = models.TextField(null=True)
    nameinuse = models.TextField(null=True)
    employeeno = models.TextField(null=True)
    departmentname = models.TextField(null=True)

    def __str__(self):

        return '{} {}'.format(self.nameinuse, self.employeeno)


class Region(models.Model):

    regionname = models.TextField(null=True)
    regionalincharge = models.ForeignKey(Employees, on_delete=models.CASCADE,null = True)

当我使用datalist = Region.objects.all()时，我希望Employees表中不同变量或数组中的所有字段都在模板中使用

Answer 1

# If this is your query in your views function or class

datalist = Region.objects.all()


# then you can access 'Employees' data in your template by using '.' operator. 

For example

views.py

def view_function(request):
    datalist = Region.objects.all()
    return render(request, 'template_name.html', { 'datalist': datalist })



template_name.html

{% for data in datalist %}
    <p>{{data.regionalincharge.nameininitials}}</p>
    <p>{{data.regionalincharge.nameinuse}}</p>
    <p>{{data.regionalincharge.employeeno}}</p>
    <p>{{data.regionalincharge.departmentname}}</p>
    <hr />
{% endfor %}