How to display Django array data

Question

I am using Django and PostgreSQL. I have inserted some data into the models array field. My models are like

class PurchaseInvoice(models.Model):
    invoice = models.CharField(max_length=20)
    date = models.DateField(default=date.today)
    product_name = ArrayField(models.CharField(max_length=500))
    price = ArrayField(models.CharField(max_length=300))
    quantity = ArrayField(models.CharField(max_length=200))
    amount = ArrayField(models.CharField(max_length=300))

I have inserted data successfully, but when I try to query my data I get like ["['LNB Inverto', 'Dish']"]. I want to view my data in an HTML table. My views.py file is as the following:

def purchaseDetails(request,pk):
    invo_data = PurchaseInvoice.objects.filter(invoice=pk)
    return render(request,'purchase/invoice_details.html',{'invoice':invo_data})

And my HTML tables like:

{% for data in invoice %}
    <tr>
        <td>{{data.product_name}}</td>
        <td>{{data.price}}</td>
        <td>{{data.quantity}}</td>
    </tr>
{% endfor %}

iamdipta · Accepted Answer · 2021-08-25 19:24:40Z

1

{% for data in invoice %}
    <tr>
        <td>
            {% for name in data.product_name %}
                {{ name }}
            {% endfor %}
        </td>
        <td>{{ data.price }}</td>
        <td>{{ data.quantity }}</td>
    </tr>
{% endfor %}

happy coding :)

answered Aug 25, 2021 at 19:24

iamdipta

3663 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shanzedul Over a year ago

I got ['LNB Inverto', 'Dish']

Peter Mortensen · Accepted Answer · 2021-11-09 22:21:37Z

0

Try to the following code. Your code is almost 100% right, I think, but I don’t know why the query returns like this: ["['LNB Inverto', 'Dish']"].

PurchaseInvoice.objects.all().filter(invoice=pk)

So try to do this query. Maybe your problem will be solved.

edited Nov 9, 2021 at 22:21

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Aug 25, 2021 at 19:25

Engr Tanveer sultan

1932 silver badges8 bronze badges

1 Comment

Engr Tanveer sultan Over a year ago

ca you project file with me i check it

Collectives™ on Stack Overflow

How to display Django array data

2 Answers 2

happy coding :)

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

happy coding :)

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related