blocks|key|398659|text|Reserved.objects.filter(client=client_id).order_by('-check_in')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|398660|请注意check_in之前的-。|unstyled|offset|length|style|CODE|398661|Django+Documentation|398662|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/dev/ref/models/querysets/#order-by^0|0|3|8|E|1|0|0|K|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|V|8|@$G|W|H|X|I|J]|$G|Y|H|Z|I|J]]|9|@]|A|$]]|$1|K|3|L|5|F|7|10|8|@]|9|@$G|11|H|12|1|13]]|A|$]]|$1|M|3|-4|5|F|7|14|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

<pre><code>Reserved.objects.filter(client=client_id).order_by('-check_in')
</code></pre>

Notice the <code>-</code> before <code>check_in</code>.

<a href="https://docs.djangoproject.com/en/dev/ref/models/querysets/#order-by" rel="noreferrer" title="Documentation">Django Documentation</a>

blocks|key|614743|text|Reserved.objects.filter(client=client_id).order_by('-check_in')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|614744|"check_in“前面的连字符"-”表示降序。升序是隐含的。|unstyled|614745|我们不必在filter()之前添加all()。这仍然有效，但只有当您想要根QuerySet中的所有对象时，才需要添加all()。|614746|更多信息请点击这里：https://docs.djangoproject.com/en/dev/topics/db/queries/#retrieving-specific-objects-with-filters|offset|length|614747|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/dev/topics/db/queries/#retrieving-specific-objects-with-filters^0|0|0|0|A|2P|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|V|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|F|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

<pre><code>Reserved.objects.filter(client=client_id).order_by('-check_in')
</code></pre>

A hyphen "-" in front of "check_in" indicates descending order. Ascending order is implied.

We don't have to add an all() before filter(). That would still work, but you only need to add all() when you want all objects from the root QuerySet.

More on this here:
<a href="https://docs.djangoproject.com/en/dev/topics/db/queries/#retrieving-specific-objects-with-filters" rel="noreferrer">https://docs.djangoproject.com/en/dev/topics/db/queries/#retrieving-specific-objects-with-filters</a>

blocks|key|615001|text|添加-将按降序排列。您还可以通过向模型的元添加默认排序来设置此设置。这意味着当你做一个查询时，你只要做MyModel.objects.all()，它就会以正确的顺序出现。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|615002|class+MyModel(models.Model):

++++check_in+=+models.DateField()

++++class+Meta:
++++++++ordering+=+('-check_in',)|code-block|syntax|javascript|615003|entityMap^0|1F|L|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Adding the - will order it in descending order.
You can also set this by adding a default ordering to the meta of your model. This will mean that when you do a query you just do <code>MyModel.objects.all()</code> and it will come out in the correct order.
<pre><code>class MyModel(models.Model):

 check_in = models.DateField()

 class Meta:
 ordering = ('-check_in',)
</code></pre>

blocks|key|614845|text|您还可以使用以下指令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|614846|Reserved.objects.filter(client=client_id).order_by('check_in').reverse()|code-block|syntax|javascript|614847|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can also use the following instruction:

<pre><code>Reserved.objects.filter(client=client_id).order_by('check_in').reverse()
</code></pre>

blocks|key|398941|text|对于升序：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|398942|Reserved.objects.filter(client=client_id).order_by('check_in')|code-block|syntax|javascript|398943|对于降序：|398944|1.++Reserved.objects.filter(client=client_id).order_by('-check_in')|398945|或|398946|2.++Reserved.objects.filter(client=client_id).order_by('check_in')[::-1]|398947|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

for ascending order:

<pre><code>Reserved.objects.filter(client=client_id).order_by('check_in')
</code></pre>

for descending order:

<pre><code>1. Reserved.objects.filter(client=client_id).order_by('-check_in')
</code></pre>

or

<pre><code>2. Reserved.objects.filter(client=client_id).order_by('check_in')[::-1]
</code></pre>

blocks|key|614799|text|移除.all()是可行的|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|614800|Reserved.objects.filter(client=client_id).order_by('-check_in')|code-block|syntax|javascript|614801|entityMap^0|2|6|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

It works removing <code>.all()</code>:

<pre><code>Reserved.objects.filter(client=client_id).order_by('-check_in')
</code></pre>

blocks|key|399088|text|如果由于某种原因你有空值，你可以使用F函数，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|399089|from+django.db.models+import+F|offset|length|style|CODE|399090|Reserved.objects.all().filter(client=client_id).order_by(F('check_in').desc(nulls_last=True))|399091|所以它会把空值放在最后。Django提供的文档：https://docs.djangoproject.com/en/stable/ref/models/expressions/#using-f-to-sort-null-values|399092|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/stable/ref/models/expressions/#using-f-to-sort-null-values^0|0|0|U|0|0|2L|0|O|2K|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|10|8|@]|9|@$D|11|E|12|1|13]]|A|$]]|$1|L|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

If for some reason you have null values you can use the F function like this:
<code>from django.db.models import F</code>
<code>Reserved.objects.all().filter(client=client_id).order_by(F('check_in').desc(nulls_last=True))</code>
So it will put last the null values.
Documentation by Django: <a href="https://docs.djangoproject.com/en/stable/ref/models/expressions/#using-f-to-sort-null-values" rel="nofollow noreferrer">https://docs.djangoproject.com/en/stable/ref/models/expressions/#using-f-to-sort-null-values</a>

blocks|key|399147|text|Reserved.objects.filter(client=client_id).earliest('check_in')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|399148|或者另选地|unstyled|399149|Reserved.objects.filter(client=client_id).latest('-check_in')|399150|以下是earliest()和latest()的文档|offset|length|style|CODE|399151|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/3.1/ref/models/querysets/#earliest|1|https://docs.djangoproject.com/en/3.1/ref/models/querysets/#django.db.models.query.QuerySet.latest^0|0|0|0|3|A|E|8|3|A|0|E|8|1|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|Z|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|11|8|@$K|12|L|13|M|N]|$K|14|L|15|M|N]]|9|@$K|16|L|17|1|18]|$K|19|L|1A|1|1B]]|A|$]]|$1|O|3|-4|5|F|7|1C|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|X]]]]

<pre><code>Reserved.objects.filter(client=client_id).earliest('check_in')
</code></pre>
Or alternatively
<pre><code>Reserved.objects.filter(client=client_id).latest('-check_in')
</code></pre>
Here is the documentations for <a href="https://docs.djangoproject.com/en/3.1/ref/models/querysets/#earliest" rel="nofollow noreferrer"><code>earliest()</code></a> and <a href="https://docs.djangoproject.com/en/3.1/ref/models/querysets/#django.db.models.query.QuerySet.latest" rel="nofollow noreferrer"><code>latest()</code></a>

blocks|key|398958|text|这对我很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|398959|latestsetuplist+=+SetupTemplate.objects.order_by('-creationTime')[:10][::1]|code-block|syntax|javascript|398960|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This is working for me.

<pre><code>latestsetuplist = SetupTemplate.objects.order_by('-creationTime')[:10][::1]
</code></pre>

blocks|key|399055|text|67|type|unstyled|depth|inlineStyleRanges|entityRanges|data|399056|Reserved.objects.filter(client=client_id).order_by('-check_in')|399057|'-‘表示降序，对于升序，只提供class属性|399058|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

67

Reserved.objects.filter(client=client_id).order_by('-check_in')

'-' is indicates Descending order and for Ascending order just give class attribute

How can I order by descending my query set in django by date?

<pre><code>Reserved.objects.all().filter(client=client_id).order_by('check_in')
</code></pre>

I just want to filter from descending all the Reserved by check_in date.

django order_by query set, ascending and descending

如何对django中的查询集按日期降序排序？Reserved.objects.all().filter(client=client_id).order_by('check_in')我只想从降序过滤所有保留的check_in日期。

问django order_by查询集，升序和降序
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问django order_by查询集，升序和降序EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问django order_by查询集，升序和降序
EN