Skip to Content
Menu
This question has been flagged
2 Replies
1547 Rodiniai

'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

Portretas
Atmesti
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

Portretas
Atmesti
Autorius Best Answer

Thank so much !

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
1
liep. 25
1688
1
geg. 25
1673
1
bal. 25
2262
1
vas. 25
1550
0
spal. 24
1306