开发者

Make filters of an object list

开发者 https://www.devze.com 2023-03-26 14:03 出处:网络
I get from my database a list of objects with attributes. So I want to make dynamics filters on the left depends of my list results.

I get from my database a list of objects with attributes. So I want to make dynamics filters on the left depends of my list results.

For example, if i have an advertisement on "Paris" and "New York" i want to see Paris(1), New york (1) on the left. When you click on it, you will see just Paris' advertisement or New 开发者_开发知识库york's.

What is the best way to do that?

Thank you!


from django.db.models import Q
Advertisement.objects.filter( Q(name = 'Paris') | Q(name = 'New York') )

You need to use filters and Q objects.


You can use the aggregation https://docs.djangoproject.com/en/dev/topics/db/aggregation/#generating-aggregates-for-each-item-in-a-queryset

exemple:

cities = City.objects.annotate(ads_count=Count("adevertissement"))
0

精彩评论

暂无评论...
验证码 换一张
取 消