在Django中获取下一个和前一个对象 [英] Getting next and previous objects in Django

问题描述

我正在试图获得漫画书的下一个和前一个对象。只需更改身份证号码或过滤通过添加的日期就不会有效，因为我不会顺序添加问题。

I'm trying to get the next and previous objects of a comic book issue. Simply changing the id number or filtering through date added is not going to work because I don't add the issues sequentially.

这是我的视图是如何设置的，它工作对于 prev_issue 并返回上一个对象，但返回 next_issue 的最后一个对象，我不知道为什么。

This is how my views are setup and it WORKS for prev_issue and does return the previous object, but it returns the last object for next_issue and I do not know why.

def issue(request, issue_id):
issue = get_object_or_404(Issue, pk=issue_id)
title = Title.objects.filter(issue=issue)
prev_issue = Issue.objects.filter(title=title).filter(number__lt=issue.number)[0:1]
next_issue = Issue.objects.filter(title=title).filter(number__gt=issue.number)[0:1]

推荐答案

添加一个 order_by 子句，以确保它按号 p>

Add an order_by clause to ensure it orders by number.

next_issue = Issue.objects.filter(title=title).filter(number__gt=issue.number).order_by('number')[0:1]

这篇关于在Django中获取下一个和前一个对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！