babywd 发表于 2014-02-14 17:55

求问个用django模型查询的问题

问下 用django的查找功能
SELECT solve_question_user, COUNT(solve_question_user) AS dcount ,(select count(1) from cmdb_solve where solve_faq='1' )AS yes , (select count(1) from cmdb_solve where solve_faq='2') AS no FROM cmdb_solveGROUP BY solve_question_user 这种SQL在django怎么写啊


solves= Solve.objects.values('solve_question_user','solve_user_departments__departments_name').annotate(dcount=Count('solve_question_user')).order_by('-dcount')
我自己写出来了,然后就无头绪了。。

樱落花开 发表于 2014-02-14 18:02

babywd 发表于 2014-02-17 09:51

求大神帮助啊，快来看看呀
页: [1]
查看完整版本: 求问个用django模型查询的问题