Django - regrouping and filtering

Using Django Templates & Frontend
1

model

class costdata(models.Model):
	date = models.DateField()
	type = models.CharField(choices=expense_choice,max_length=250)
	expense = models.CharField(max_length=250)
	amount = models.FloatField(default=0.0)

views

costdata = costdata.objects.values('type','expense','date__month').filter(date__range=[fromdat,todat]).annotate(total = Sum('amount'))

In template I need to show data related to type=‘something’. How can I filter that in regroup?

{% regroup costdata|dictsort:"expense" by expense as expense_list %}

No clue what to do after this? How can I filter with type=''something"?

2

You don’t do that in the template. You change your view to filter the data before it is rendered.

3

Tried this:

But no idea where its wrong.

{% regroup costdata|dictsort:"expense" by expense as expense_list %}

{% for k,v in expense_list %}
{% for data in v %}
{% if data.type == 'cm2' %}
{% regroup data by data.expense as el %}
{% for a in el %}
{{a.grouper}}<br>
{% endfor %}
{% endif %}
{% endfor %}
{% endfor %}

Here the result is None.