- changed status to open
Sum up fields in sub-tasks and show the result in story
I have a list of sub-tasks let say sub-task 1, sub-task 2 and sub-task 3, now I have fields design and build on all the sub-tasks. Now I enter 1 for design and 2 for build on all the sub-tasks, I should see the result of 3 for the design field in the story and 6 for build field. How can this be achieved, is there an add-on to get pass this issue?
Below is an example of what I am trying to explain
Story
Field 1 = 1+5+3
Field 2 = 3+6+4
Sub-Task 1 Sub-task 2 Sub-task 3
Field 1 = "1" Field 1 = "5" Field 1 = "3" Field 2 = "3" Field 2 = "6" Field 2 = "4"
Comments (20)
-
reporter -
repo owner My answer is on the same question at help forum: https://groups.google.com/d/msg/jira-workflow-toolbox-plugin/XIBbPPG4AqQ/AU1Gw003BgAJ.
-
reporter That was really an awesome explanation thank you so much for taking so much time in implementing that and explaining me, but I implemented the same steps that you said and the target field (i mean the Parent X field will not show any value in it)
-
repo owner Are you editing the field through the screen in "Edit special fields" transition?
Please, attach a screenshot of the post-function's tab of "Edit special fields" transition.
-
reporter PFA the post function that I am using, and no I am not editing the fields from transition screen, I am entering the values for all the fields at the subtask level and waiting to see them update at the story level
-
repo owner Firstly, you should use field code %{00041} as argument of subtask() function. That field code is for field "Parent's issue key", but you have mistakenly inserted different field code (the one for Sprint custom field).
Secondly, you should also insert the post-function in "Create Issue" transition for those fields to be synchronized which are also in create screen. Always insert your post-functions after "Creates the issue originally" post-function.
Take into account that parent issue's field is updated only when the post-function is executed.
-
reporter Thanks again for the prompt reply Fidel, So correct me if I am wrong both the post functions should be on the subtask workflow itself am I correct :)
-
repo owner Yes, the "Mathematical and date-time expression calculator" post-functions I described are only inserted in subtask's workflow.
-
repo owner Hi Bharath,
After watching your video showing the failure I can give you the changes you have to do in order to make it work:
-
You have to select "Parent's Design - Story" in parameter target field, instead of "Design - Story". You have to do it in both post-functions (the one at "Create Issue" and the one at "Edit special fields").
-
You have to associate "Synchronized Fields" screen to "Edit special fields" transition. You have to edit the transition to do it. Sorry, I forgot to mention it in my instructions.
With those two changes it will work.
-
-
reporter That works perfectly fine and I am really happy now Fidel " Many many thanks to you " I will have a demo of this feature today and will soon have the purchase made on the marketplace
Cheers Bharath Kumar
-
repo owner - changed status to resolved
Great! Thanks.
-
repo owner Hi Bharath,
I answer your question:
"One more small addition to the task, now that I have all the synchronized fields summed up on the parent issue I would also like to show the total value of the synchronized fields( meaning sum of all the synchronized fields on the parent issue) is that possible."
You should add to "Create Issue" and "Edit special fields" transitions a instance of "Mathematical and date-time expression calculator" with the following configuration:
- Target field: Parent's Sum of special fields (I'm assuming it's a numeric custom field you have created for storing the sum of synchronized fields).
- Formula: enter a formula built with each formula used for updating each synchronized field separated by operator '+'. Example:
sum(fieldValue({aaaaa}, subtasks(%{00041}))) + sum(fieldValue({bbbbb}, subtasks(%{00041}))) + sum(fieldValue({ccccc}, subtasks(%{00041})))
assuming that aaaaa, bbbbb and ccccc are field codes for each synchronized custom field.
-
repo owner Hi Bharath,
In your video I can see 2 screens associated with "T Size" field, and according to the names it seemed that one of them is Edit screen. Maybe those names don't correspond with their actual functionality.
Anyway, I already know which is the problem. You forgot a '+' operator between 2 sub-formulas. And, if you read carefully the configuration screen, you will see that the parser is informing you that there is a parsing error. The formula you should use is:
sum(fieldValue({10500}, subtasks(%{00041}))) + sum(fieldValue({10501}, subtasks(%{00041}))) + sum(fieldValue({10502}, subtasks(%{00041}))) + sum(fieldValue({10503}, subtasks(%{00041}))) + sum(fieldValue({10504}, subtasks(%{00041}))) + sum(fieldValue({10505}, subtasks(%{00041}))) + sum(fieldValue({10506}, subtasks(%{00041}))) + sum(fieldValue({10507}, subtasks(%{00041}))) + sum(fieldValue({10508}, subtasks(%{00041})))
Please, let me know if it solves the problem.
-
reporter Ya that works perfectly fine for me, sorry I was busy doing other work so could not respond to your message, you are a great man thanks for all the help.
-
reporter - attached Docs.docx
- edited description
- attached ICMP DEV OPS Jira and Confluence Approach.docx
-
reporter - attached STEMOPTMailingInstructions.12.20.16.pdf
- attached Steve's Bridge.msg
- attached STEMOPTExtensionRequest.pdf
- attached Bhharath.docx
- attached MyED.msg
- attached Insurance copy.pdf
- attached ICMP DEV OPS Jira and Confluence Approach.docx
- attached Costco Number.msg
- attached Chrome Bookmarks.html
- attached ADP.msg
- attached Scrum Training Manual.pdf
- attached Scrum Master Accredited Certificate - Bharath.pdf
- attached Permier Account.msg
-
reporter - attached Jira.6X.pdf
- attached JIRA.5.x.pdf
-
reporter - attached req.txt
- attached Macro CLI.txt
- attached CLI Workingn.txt
-
reporter - attached Docs.docx
-
reporter - Log in to comment