Django:使用childs外键获取父数据

Question

使用child获取父数据时遇到问题

models.py

class Company_Data(models.Model):
    company_name = models.CharField(max_length=254)
    company_address =  models.CharField(max_length=254)
    company_tel_no =  models.CharField(max_length=254)
    company_fax_no = models.CharField(max_length=254)


class Requirements(models.Model):
    req_service         = models.CharField(null=False, max_length=254)
    req_coverdate_from  = models.DateField()
    req_coverdate_to    = models.DateField()
    req_duedates        = models.DateField()
    company             = models.ForeignKey(Company_Data, on_delete=models.CASCADE)

views.py

def business_setup(request):

    req = Requirements.objects.filter(req_service = 'Business Setup')

    context = {
        'req' : req ,
    }
    return render(request, 'admin_template/content/admin_businesssetup_req.html', context)

模板HTML

{% for requirements in req %}
<table>
                    <tbody>

                      <tr>
                      <th style="width:50%">Company Name</th>
                      <td>{{ requirements.company_id.company_name }}</td>
                      </tr>

                      <tr>
                      <th> Covered Date From </th>
                      <td>{{ requirements.req_coverdate_from }}</td>
                      </tr>
                      <tr>
                      <th> Covered Date To </th>
                      <td>{{ requirements.req_coverdate_to }}</td>
                      </tr>
                      <tr>
                      <th> Due Date </th>
                      <td>{{ requirements.req_duedates }}</td>
                      </tr>
                    </tbody>
                  </table>

{% endfor %} 

我尝试的是requirements.company_id.company_name显示相关的公司名称，但没有运气。我发现的是查询父级Company_Date以显示子级Requirements。但是我想过滤Requirements表并显示它的父级，所以这些不适用于我

谢谢

Answer 1

You just have to write "company" instead of "company_id" in your template

<td>{{ requirements.company.company_name }}</td>

Answer 2

就用这个吧

<td>{{ requirements.company__name }}</td>

有关更多信息，请访问本link中的django文档页面