最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

jql - Jira Query Language for Structure Board - Stack Overflow

programmeradmin3浏览0评论

I have to update capacity calculating formula for my team members for each quarter manually. Instead of doing this manual work I want to assign some variables on top of my code. Thus I can only update variable on top of the code. But I could not do that.

WITH M1_username = "username1":
WITH M1_username = "username2":
WITH M1_username = "username3":
WITH M1_username = "username4":

WITH SPRINT1 = "*Sprint 23.1 (wk15-16)*":
WITH SPRINT2 = "*Sprint 23.2 (wk17-18)*":
WITH SPRINT3 = "*Sprint 23.3 (wk19-20)*":

WITH M1_capSP1 = 7:

WITH M1_username = "omerk":

WITH M1_name = "Omer":

WITH PerHigh = 1.1:
WITH PerLow  = 0.9:

................

if ( notes = "SPRINT1", concat(
                //Member1
        if(ceiling(number(sum{if(match(sprint,"SPRINT1") and assignee = "M1_username" ,storypoints)},0),1)>M1_capSP1*PerHigh,"{color:red}",
        if(ceiling(number(sum{if(match(sprint,"SPRINT1") and assignee = "M1_username" ,storypoints)},0),1)<M1_capSP1*PerLow,"{color:blue}","{color:34E536}")),
        M1_name,":",ceiling(number(sum{if(match(sprint,"SPRINT1") and assignee = "M1_username" ,storypoints)},0),1),"/", M1_capSP1," ----- ","{color}"
        
        ..............
        
concat("{color}")))
发布评论

评论列表(0)

  1. 暂无评论