django last tag object is not subscriptable

Question

I apologies to ask but...

I been trying on this "last" tags in my HTML with my Django framework to bring out the last object in my database to be display on my html; here doc:https://docs.djangoproject.com/en/2.1/ref/templates/builtins/

Now the problem was when I use my "last" tags on my code;

<div class = "float-right  my-4 chartjs-render-monitor" id="chartContainerPH" style="width: 49%; height: 400px;display: inline-block; background-color:#FDFDFD;">
<center>
    <a class="title-link" href="{%url 'ph' %}">PH:</a>
    <p> {% for tank_system in tank %}{{tank_system.PH|last}}, {%endfor%}</p>
    </center>

</div>

and get this errors;

TypeError at /
'decimal.Decimal' object is not subscriptable
Request Method: GET
Request URL:    http://127.0.0.1:8000/
Django Version: 2.1.3
Exception Type: TypeError
Exception Value:    
'decimal.Decimal' object is not subscriptable
Exception Location: C:\Users\user\AppData\Local\Programs\Python\Python37-32\lib\site-packages\django\template\defaultfilters.py in last, line 540
Python Executable:  C:\Users\user\AppData\Local\Programs\Python\Python37-32\python.exe
Python Version: 3.7.1
Python Path:    
['C:\\Users\\user\\Desktop\\FrounterWeb- postgreDB',
 'C:\\Users\\user\\AppData\\Local\\Programs\\Python\\Python37-32\\python37.zip',
 'C:\\Users\\user\\AppData\\Local\\Programs\\Python\\Python37-32\\DLLs',
 'C:\\Users\\user\\AppData\\Local\\Programs\\Python\\Python37-32\\lib',
 'C:\\Users\\user\\AppData\\Local\\Programs\\Python\\Python37-32',
 'C:\\Users\\user\\AppData\\Local\\Programs\\Python\\Python37-32\\lib\\site-packages']
Server time:    Thu, 6 Dec 2018 11:12:47 +0800

I'm not clear on this errors but even after read here: In Python, what does it mean if an object is subscriptable or not?

here's my code on models;

from django.db import models
from django.utils import timezone
# having errors KeyError: "'__name__' not in globals"

class tank_system(models.Model):
    PH = models.DecimalField(max_digits=3, decimal_places=1)
    EC = models.DecimalField(max_digits=3, decimal_places=1)
    WaterLevel = models.IntegerField(default=100)
    TempWater = models.IntegerField(default=0)
    TempRoom = models.IntegerField(default=0)
    datetime = models.DateTimeField(default=timezone.now())



    def get_last(self):
        try:
            print(self)
            return self.set.all().order_by('-date')[0]
        except IndexError:
            pass

here my code on views;

from django.shortcuts import render
from django.views.generic import TemplateView
from zigview.models import tank_system

from django.contrib.auth.decorators import login_required
import logging
logger = logging.getLogger(__name__)
from django.core.mail import send_mail



try:
    @login_required(login_url='/accounts/login/')
    def index(request): #gose to main dashboard page
        #tank = tank_system.objects.all()
        tank = tank_system.objects.extra(select={'is_recent':"datetime>'2006-01-01'"})
        return render(request,'FrounterWeb/extends/includes.html',{'tank':tank})
except:
    logger.error('index page request failed/errors')

I apologies to ask

Answer 1

You can test whether the for loop is referencing the last item with forloop.last, and then look up the PH attribute on that:

<center>
    <a class="title-link" href="{%url 'ph' %}">PH:</a>
    <p> 
       {% for tank_system in tank %}
           {% if forloop.last %}
               {{ tank_system.PH }}, 
           {% endif %}
       {% endfor %}
    </p>
</center>

It seems that trying to use Django's last template tag on the queryset of tanks will give the "Negative indexing is not supported" error.