How to access Product name and all details from sub Category using Django?

I want to get product name and all its details from sub category, I tried a lot to find how to do it but it didn't work

When clicking on the sub category the related products should appear ,If anyone knows the query please tell me

I have made four models
First Main category
Second category
Third SubCategory

Category contains the foregion key of the main category
Also
In sub category the foregion key of category is given

And in the product model, the foreign key of the above three models is given

I try this query Product.objects.all().select_related('main_category').select_related('category').select_related('sub_category')
Please tell me and its html part too

To retrieve the product name and all its details based on the subcategory, you can use the Django ORM and the select_related method. Assuming you have the following models:

class MainCategory(models.Model):
    name = models.CharField(max_length=100)

class Category(models.Model):
    name = models.CharField(max_length=100)
    main_category = models.ForeignKey(MainCategory, on_delete=models.CASCADE)

class SubCategory(models.Model):
    name = models.CharField(max_length=100)
    category = models.ForeignKey(Category, on_delete=models.CASCADE)

class Product(models.Model):
    name = models.CharField(max_length=100)
    main_category = models.ForeignKey(MainCategory, on_delete=models.CASCADE)
    category = models.ForeignKey(Category, on_delete=models.CASCADE)
    sub_category = models.ForeignKey(SubCategory, on_delete=models.CASCADE)
    # other fields

To fetch the products and their details based on a specific subcategory, you can use the following query:

subcategory_id = 1  # Replace with the desired subcategory ID

products = Product.objects.filter(sub_category_id=subcategory_id).select_related(
    'main_category', 'category', 'sub_category'
)

In the above example, subcategory_id represents the ID of the subcategory for which you want to retrieve the products. Replace it with the actual subcategory ID you are interested in.

The select_related method is used to fetch related fields in a single database query, improving performance. In this case, we specify the related fields to include: main_category, category, and sub_category.

To display the products and their details in HTML, you can iterate over the products queryset in your template. Here's an example of how you can display the product names and related details:

<ul>
  {% for product in products %}
    <li>
      <strong>Product Name:</strong> {{ product.name }}<br>
      <strong>Main Category:</strong> {{ product.main_category.name }}<br>
      <strong>Category:</strong> {{ product.category.name }}<br>
      <strong>Subcategory:</strong> {{ product.sub_category.name }}<br>
      <!-- Display other product details as needed -->
    </li>
  {% endfor %}
</ul>

In this example, the product names and related details are displayed using template variables ({{ variable_name }}). Adjust the HTML structure and the displayed fields according to your specific requirements.