我在Django(5.0.4)上有一个模型,有可 Select 的月份和年份,如下所示:
class Item(models.Model):
MONTHS_CHOICES = [
('JANUARY', 'January'),
('FEBRUARY', 'February'),
('MARCH', 'March'),
('APRIL', 'April'),
('MAY', 'May'),
('JUNE', 'June'),
('JULY', 'July'),
('AUGUST', 'August'),
('SEPTEMBER', 'September'),
('OCTOBER', 'October'),
('NOVEMBER', 'November'),
('DECEMBER', 'December')
]
month = models.CharField(max_length=9, choices=MONTHS_CHOICES, default="JANUARY", db_index=True)
year = models.IntegerField(default=0)
(...)
如果我try 按Item.objects.all().order_by("-year", "month")
年和Item.objects.all().order_by("-year", "month")
年订购物品.
从逻辑上讲,月份将按字母顺序排序.
我可以做些什么才能按照与MONTHS_CHOICES
月份相同的订单订购的商品?
Option B只是重新设计模型,以包括只有年份和月份的DateField
,比如this question here,然后按该字段订购
我也try 了this page的解决方案,但对我来说都没有任何效果.