pass queryset data to javascript as a variable template

Question

I am trying to pass queryset data to the template as a javascript variable. I know I am doing something silly that is not working.

views.py 

from django.http import HttpResponse
from django.template import Context,Template,RequestContext
from django.shortcuts import render_to_response, render
from django.conf.urls.static import static
from django.contrib import admin
from django.contrib.staticfiles.urls import staticfiles_urlpatterns
from django.template.context_processors import csrf
from io import TextIOWrapper
from django.core.mail import send_mail
from django.utils.safestring import mark_safe
from django.db import connection
import os
import json
import xlrd
from django import forms
from django.forms import ModelForm
from django.db import models
from .models import Deliveries
# Create your views here.

def historicals(request):
    context = {}          
    historicals= Deliveries.objects.all()[1:100]
    print (historicals)
    context['historicals']=historicals
    context['abc']=123
    return render(request,'customer.html',context)

then the

customer.html
{% extends "base.html" %}
{% load static %}
    <script type="text/javascript">
    //{% autoescape off %}{{ historicals }}{% endautoescape %}; <--tried this too
           var actuals = {{ historicals | safe }};
           var abc = {{ abc | safe }}   ;
        </script>
        <script src="{% static 'js/custom.js' %}"></script>
    {% block content %}         
            {% for i in actuals %}
                {{ i.Date }}
            {% endfor %}            
            <h1> {{ abc }} </h1> 
    {% endblock content %}

Heres the confusion.

When I print the historicals, the queryset shows in the console. It tells me that models, the connectivity to db and query is working.
I am able to pass value 'abc' =123 to the template and it shows up in customer.html correctly

What am I doing wrong for the historicals queryset to not even show up in the template (I checked view source, its blank) but simple variable shows up?

Add python and django tags

bharat.goli
– bharat.goli

2020-06-23 12:00:20 +00:00
Commented Jun 23, 2020 at 12:00 — bharat.goli
– bharat.goli, Commented Jun 23, 2020 at 12:00
just added tags

user2162611
– user2162611

2020-06-23 12:05:32 +00:00
Commented Jun 23, 2020 at 12:05 — user2162611
– user2162611, Commented Jun 23, 2020 at 12:05

minglyu · Accepted Answer · 2020-06-23 20:06:07Z

9

You can use Django builtin serilizers to pass data to js for queryset.

# views.py
from django.core import serializers

historicals = serializers.serialize("json", Deliveries.objects.all())

# html
<script type="text/javascript">
   // construct js objects
   var actuals = JSON.parse('{{ historicals | safe }}')
</script>

EDIT

if you would like to loop in django template, you just need to pass delivers queryset, no need parse as js variables.

# views.py
diliveries = Deliveries.objects.all()

# html
{% for i in deliveries %}
  {{ i.Date }}
{% endfor %}

edited Jun 23, 2020 at 20:06

answered Jun 23, 2020 at 14:45

minglyu

3,3872 gold badges17 silver badges38 bronze badges

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

2 Comments

user2162611 Over a year ago

Thanks ! @minglyu. I can see the data dictionary in json better in command console but still cannot see the data in the template at all.

minglyu Over a year ago

@user2162611 template needs python variables, actuals are javascripts objects, which can not be used for Django template language, if you want to loop through the variables, you need to follow js syntax.

Collectives™ on Stack Overflow

pass queryset data to javascript as a variable template

1 Answer 1

EDIT

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

EDIT

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related