Find different category into all product in Django

Question

I have a list of all products which belong to different categories.

model.py

 class Product(models.Model):
        product_name = models.CharField(max_length=50,null=True, blank=True)
        details = models.CharField(max_length=100, null=True, blank=True)
        company_name = models.CharField(max_length=50,null=True, blank=True)
        category = models.ForeignKey(ProductClass,null=True, blank=True)

Category is a ForeignKey of ProductClass.

Now I want a list of all different categories. I do not want a list of repetitive categories. For that I tried obj = CustomerLeads.objects.all()

obj = Product.objects.all()


    c = []
        for i in obj:
            c.append(i.item_required)

        cat = set(c)
        return JsonResponse({'data':cat})

I am getting error set([<ProductClass: accessories>, <ProductClass: other>]) is not JSON serializable

How can I get a list of all different categories?

Error is quiet clear, `set([, ])` is set of ProductClass instances which are obviously non serializable when you are trying to send them through JsonResponse. Try to send a dictionary of categories with name, id and whatever data you need. — Rajesh Yogeshwar, Dec 15 '16 at 08:26
What does `CustomerLeads` have to do with anything? Isn't it just `ProductClass.objects.all()`? Where are you trying to get this list?.. — Sayse, Dec 15 '16 at 08:41
Try this: `categories = list(set(Product.objects.values_list('category__name')))` — Asif, Dec 15 '16 at 15:20

score 0 · Answer 1 · edited May 23 '17 at 12:30

0

distinct() eliminates the duplicate element of queryset .

values_list(*field, flat=True) are used to return the values as list.

 Product.objects.values_list('category__category_name', flat=True).distinct()

#output
[u'Lamps', u'Professional', u'LED', u'Automotive']

Reference

edited May 23 '17 at 12:30

Community

1
1

answered Dec 15 '16 at 18:25

Ibrahim Kasim

1,414
1
10
9

Find different category into all product in Django

1 Answers1