I use the following query to sum the fields in the subtask :
for that query, was successfully executed.
then, I use the following query to sum the fields in the linkissue :
but I get the following error message:
Did I miss something?
the name of the filter is linkedIssues (with an "s")
Hi @David Fischer ,
as always, thanks for the feedback :)
but I have a question,
after adding “s” to LinkIssues, I get the following “Warning” message:
What does the warning mean?
Do I need to change anything else?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That's because you need to pass the list of fields as an array:
linkedIssues(["customfield_12529"])
However, to be fair, I haven't tested this without passing an outside link type name as the first parameter.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @David Fischer,
I tried it, and it worked!!
here's the query:
{{ targetIssue | linkedIssues(["customfield_12529"]) | sum("fields.customfield_12529") }}
and here's how it looks:
thanks to you, David!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @David Fischer ,
sorry to ask you again,
if I want to add a query so that only specific issuetype ( MoA Project ) can be processed, how can I do that?
Note:
MoA Project is a subtask
thank you very much in advance, David
You've helped a lot.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
do you mean that only want to sum the customfield_12529 field only on the linked issues of a certain issue type? Or only calculate the value if the current issue is of a certain issue type?
Assuming the former, you can do this:
{{ targetIssue | linkedIssues(["customfield_12529", "issuetype"]) | filter(["fields.issuetype.name","MoA Project"]) | sum("fields.customfield_12529") }}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @David Fischer ,
"do you mean that only want to sum the customfield_12529 field only on the linked issues of a certain issue type?"
>> Yes, this is the right one, and I just tried it, and it worked.
Thanks, David :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @David Fischer ,
Today (June 05, 2024) I have a problem with this process,
so when I tried to replicate the process, the result is always 0, as you can see on the images below:
But the other day when I tried to run the process,
it works perfectly and there is no error that happened that day.
and heres the query that I'm using:
any suggestion from you, @David Fischer ? :(
Is this a bug? or did I miss something?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Update:
It turns out that JMWE had an issue last night, which caused it to not work properly.
When we tried it again,JMWE was working fine again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @David Fischer ,
Sorry, I wanted to ask you again,
based on the following query:
{{ targetIssue | linkedIssues(["customfield_12529", "issuetype"]) | filter(["fields.issuetype.name","MoA Project"]) | sum("fields.customfield_12529") }}
What if I want to add one more filter, with a specific value of a field, will the query form be like this?
{{ targetIssue | linkedIssues(["customfield_12529","customfield_12345","issuetype"]) | filter(["fields.issuetype.name","MoA Project"]) | filter (["Pengurangan"]) | sum("fields.customfield_12529") }}
customfield_12345 is a field of type : Select List (Single Choice)
Thank you in advance, @David Fischer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, i'm very interrested in what you do and i would like to ask you where did you use those query ? Is there in automation rules ?
I have to do something like that in automation rules.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sorry for the late reply..
Currently, I'm using Jira Misc Workflow Extensions (JMWE) workflow extension from Appfire
here's the url, if you interested :
https://marketplace.atlassian.com/apps/292/jira-misc-workflow-extensions-jmwe?tab=overview&hosting=cloud
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.