Django ORM的同一个模型中的filter比较二个字段
这里要是用db模块中的F 库才行 F object
def index(request): #stats = stationery.objects.all() stats = stationery.objects.values_list('stat_type','stat_type__name').annotate(Count('stat_type')) print(stats.query) print(stats) orders = order_record_master.objects.filter(order_status= 'submitted') ##比较当前库存量与库存告警数量, stock_alerts=stationery.objects.filter(alert_num__gte=F('stock_num')).order_by('stock_num')[0:10] return render(request,'stationery/stat_index.html', {'stats':stats ,'orders':orders,'stock_alerts':stock_alerts})