python - 不同的方法在 Django 中无法正常工作

Question

我想获得不同的季度和年份对，但以下查询给出了重复的对

DataValue.objects.values('period_quarter','period_year').distinct()

输出:

[
 {
'period_year': '2019',
'period_quarter': 'Q2'
 },
 {
'period_year': '2019',
'period_quarter': 'Q2'
 },
 {
'period_year': '2019',
'period_quarter': 'Q2'
 }
]

Answer 1

来自Docs :

When you specify field names, you must provide an order_by() in the QuerySet, and the fields in order_by() must start with the fields in distinct(), in the same order.

尝试:

DataValue.objects.order_by('period_quarter','period_year').distinct('period_quarter','period_year')