How to get only first "N" elements from postgres through views in Django using jinja

Question

I am using Django and postgres.

My views.py looks like:

def home(request):
    title = Scrap.objects
    return render(request, 'index.html', {'headlines': headlines})

My index.html looks like:

 <div class="content"
    style="background:white; color: white; font-family: Verdana;font-weight: 5;text-align: center;">
    {% for headline in headlines.all reversed %}
        <a href="{{ headline.url }}" target="_blank" style="color:black; font-size: medium;" />{{ headline.headlines }}</a>
        <hr style="border-bottom: dotted 1px #000" />
    {% endfor %}
  </div>

With the above code I am getting all the rows from the databse. How can I get only "N" rows?

I have tried:

{% for headline in headlines.all[:5] reversed %}

but it throws an error.

Could not parse the remainder: '[:5]' from 'headlines.all[:5]'

you have no reference to headlines variable in the given view function. Is that a typo? — JPG
– JPG, Commented Mar 28, 2020 at 4:46
Is there any particular reason you are trying to do this in the template rather than the view? — Matthew Gaiser
– Matthew Gaiser, Commented Mar 28, 2020 at 4:46
@MatthewGaiser i am following a tutorial and the tutor is doing in this way. That is the only reason i am doing it in the template. — gujaratiraja
– gujaratiraja, Commented Mar 28, 2020 at 4:47
@ArakkalAbu nope, this is what i am using. I might be wrong because i am following a tutorial and trying to follow that. — gujaratiraja
– gujaratiraja, Commented Mar 28, 2020 at 4:49
Are you sure that you are using Jinga2 and not Django? As that syntax looks correct. Can you give us the specific error? — Matthew Gaiser
– Matthew Gaiser, Commented Mar 28, 2020 at 4:51

JPG · Accepted Answer · 2020-03-28 05:12:23Z

2

seems like you got into the wrong tutorial. This answer is may not the exact answer you may looking for, but this will give you the idea

# views.py
def home(request):
    limit = 5
    queryset = MyModel.objects.all()[:limit]
    return render(request, 'index.html', {'queryset': queryset})

# index.html
{% for headline in queryset reversed %}
    {{ headline }}
{% endfor %}

edited Mar 28, 2020 at 5:12

answered Mar 28, 2020 at 4:56

JPG

89.4k24 gold badges164 silver badges235 bronze badges

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

1 Comment

gujaratiraja Over a year ago

getting this error: 'ellipsis' object is not iterable

gujaratiraja · Accepted Answer · 2020-03-28 19:29:30Z

1

If you want the latest (last N rows which are added to the database):

MyModel.objects.all().order_by('-id')[:10]

answered Mar 28, 2020 at 19:29

gujaratiraja

3793 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to get only first "N" elements from postgres through views in Django using jinja

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related