class sales_summary_filter(django_filters.FilterSet):
def __init__(self,request, *args, **kwargs):
super().__init__(*args, **kwargs)
self.filters['branch_name'].queryset = branch_profile.objects.filter(company_name=request.user.company_name)
class Meta:
model = sales_invoice
fields= ('branch_name', )
<form method="get">
<div id="filter_inputs" class="card filter-card">
<div class="card-body pb-0">
<div class="row">
<div class="col-md-2">
<div class="form-group">
<label>Branch:</label>
{% render_field filter.form.branch_name class="form-small form-control" %}
</div>
</div>
</div>
</div>
</div>
</form>
class branch_profile(models.Model):
company_name=models.ForeignKey(company_profile,null=True,on_delete=models.CASCADE)
branch_name=models.CharField(max_length=250)
branch_name_ar=models.CharField(max_length=250)
class Meta:
db_table = 'branch_profile'
def __str__(self):
return self.branch_name
class sales_invoice(models.Model):
company_name=models.ForeignKey(company_profile,null=True,on_delete=models.CASCADE)
branch_name=models.ForeignKey(branch_profile,null=True,on_delete=models.SET_NULL)
voucher_no=models.CharField(max_length=200,null=True)
class Meta:
db_table = 'sales_invoice'
def __str__(self):
return self.voucher_no
how to get branch_name_ar into filterset from branch_profile
now i can only access branch_name into filterset