Skip to Content
Menu
This question has been flagged
2 Replies
1063 Views

'm trying to display a list of products group by category on a Qweb Report in Odoo17. I created my list in a python class. After the process, this python list looks like this :

{
    'Office Furniture': 
    [
        {'name': 'Chair floor protection\nOffice chairs can harm your floor: protect it.', 'cat': 'Office Furniture'}, 
        {'name': 'Chair floor protection\nOffice chairs can harm your floor: protect it.', 'cat': 'Office Furniture'}
    ], 
    'Services': 
    [
        {'name': 'Deposit', 'cat': 'Services'}
    ]
}

On the Qweb side I loop through this list to display the name of products after the category. I return the category but can't figure out how display the products related to each category :


Could you please help ?

Thanks a lot

Avatar
Discard
Best Answer

Hi,
 def get_grouped_products(self):
        products = self.env['product.product'].search([])  # Fetch all products
        grouped_products = {}
        for product in products:
            category = product.categ_id.name  # Access category name
            if category not in grouped_products:
                grouped_products[category] = []
            grouped_products[category].append(product)
        return grouped_products

Hope it helps

Avatar
Discard
Author Best Answer

Thank so much !

Avatar
Discard
Related Posts Replies Views Activity
1
Apr 25
1504
1
Feb 25
535
0
Apr 25
611
0
Oct 24
532
7
Sep 24
23867