You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

Django电商应用:如何让QuerySet仅显示商品名称而非完整格式

Fixing QuerySet Display for Purchased Articles in Django Profile Page

Hey David, I see the issue you're facing—when you call order.articles.all in your template, it's rendering the full QuerySet string instead of just the clean article names. Let's walk through a few simple fixes to get that sorted:

1. Loop Through the Articles in Your Template

Since order.articles.all returns a QuerySet (a collection of OrderArticle objects), you need to iterate over each item to display its name. Update your template code like this:

{% for order in order_list %}
<div>
<p> {{ order.user }} </p>
<!-- Replace the single article line with this loop -->
{% for article in order.articles.all %}
    <p> {{ article }} </p>
{% endfor %}
<p> {{ order.ordered }} </p>
<p> {{ order.ordered_date }} </p>
</div>
{% endfor %}

For this to work properly, make sure your OrderArticle model has a __str__ method that returns the article's name. For example:

class OrderArticle(models.Model):
    # Your existing fields (like product, quantity, etc.)
    product = models.ForeignKey(Product, on_delete=models.CASCADE)
    
    def __str__(self):
        # Return the name of the associated product
        return self.product.name

2. Display All Names in a Single Line (Optional)

If you want to show all purchased articles for an order in one comma-separated line instead of separate paragraphs, you can use Django's join template filter:

<p>{{ order.articles.all|join:", " }}</p>

This will output something like Bottle of Wine, Coffee Mug—again, relying on the __str__ method in OrderArticle to return the correct name.

3. Add a Helper Method to Your Order Model (Alternative)

You can also create a custom method in your Order model to handle formatting the article names, which keeps your template cleaner:

class Order(models.Model):
    # Your existing fields (user, ordered, ordered_date, etc.)
    user = models.ForeignKey(User, on_delete=models.CASCADE)
    ordered = models.BooleanField(default=False)
    ordered_date = models.DateTimeField(null=True, blank=True)
    
    def get_purchased_articles(self):
        # Return a comma-separated string of article names
        return ", ".join([str(article) for article in self.articles.all()])

Then in your template, just call this method:

<p>{{ order.get_purchased_articles }}</p>

The root cause here is that when you print a QuerySet directly, Django outputs its default string representation (the <QuerySet [...]> format). By iterating over the QuerySet or converting it to a formatted string, you'll get the clean article names you want.

内容的提问来源于stack exchange,提问作者David

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.05.07 11:18:11