· 禪道中按產品計劃統計需求階段分布表
· 使用純sql替代報表設計
sql 語句
select t2.title， sum(t1.stage='wait') as PRD中， sum(t1.stage='planned') as PRD評審， sum(t1.stage='projected') as PRD完成， sum(t1.stage='developing') as 研發中， sum(t1.stage='developed') as 研發完畢，sum(t1.stage='testing') as 測試中， sum(t1.stage='tested') as 測試完畢， sum(t1.stage='verified') as 已驗收， sum(t1.stage='released') as 已發布， count(t2.title) as 總計 from zt_story as t1， zt_productplan as t2 where t1.plan=t2.id and t1.product='43' and t2.product='43' group by t2.title
