在 django 中排序查询对象

发布于 2024-12-29 17:04:08 字数 462 浏览 3 评论 0原文

我试图以某种父/子方式对查询结果进行排序。我想知道是否有一种简单的方法可以实现这一点。

对象：

Video : [id, parent_id, date]  // where parent_id can be null - meaning it is a 'root' node.

查询集排序我想要：

Video 1: [123, null, 01/11]
  Video 2: [111, 123, 02/11]
  Video 3: [144, 123, 04/11]

Video 4: [191, null, 03/11]
  Video 5: [118, 191, 03/11]
  Video 6: [121, 191, 05/11]

Video 7: [411, null, 04/11]

...

有没有办法在查询集中实现这种父/子组排序？

原文

I'm trying to order the results of my query in a sort of parent/child manner. I'm wondering if there's an easy way to accomplish this.

Object:

Video : [id, parent_id, date]  // where parent_id can be null - meaning it is a 'root' node.

Queryset ordering I want:

Video 1: [123, null, 01/11]
  Video 2: [111, 123, 02/11]
  Video 3: [144, 123, 04/11]

Video 4: [191, null, 03/11]
  Video 5: [118, 191, 03/11]
  Video 6: [121, 191, 05/11]

Video 7: [411, null, 04/11]

...

Is there a way to achieve this sort of parent/ child group ordering in a queryset?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

旧梦荧光笔 2025-01-05 17:04:08

如果需要在模板级别使用此功能，可以使用 regroup 模板标签对查询集重新排序：

https://docs.djangoproject.com/en/dev/ref/templates/builtins/?from=olddocs#regroup

{% regroup videos by parent_id as group %}
{% for video in group %}
    {{ video.grouper }}
    {% for child in group.list %}{{ child }}{% endfor %}
{% endfor %}

If you need to use this at the template level, you can use the regroup template tag to reorder the queryset:

https://docs.djangoproject.com/en/dev/ref/templates/builtins/?from=olddocs#regroup

{% regroup videos by parent_id as group %}
{% for video in group %}
    {{ video.grouper }}
    {% for child in group.list %}{{ child }}{% endfor %}
{% endfor %}

回复收藏 0 原文