find issue witch have substak and custom field(effort on parent) set to correct value

[Vince]

Hello,

I need to know from issue with subtask, witch of them have a custom field (effort) set to a value and send the list to teams

ex WITH ERROR : story 1 have 2 subtasks
Story 1 : have the field "effort" set to 3  <== THE ERROR IS HERE (Need to be 0)
     subtask 1 : have the field effort set to 2
     subtask 2 : have the field effort set to 1

ex WITHOUT ERROR : story without subtasks
story 2 : have the field "effort" set to 3 

ex WITHOUT ERROR : 1 story with 3 subtasks
story 3 : have the field "effort" set to 0
    subtask 1 : have the field effort set to 2
    subtask 2 : have the field effort set to 1
    subtask 3 : have the field effort set to 1

in our workflow we do not have to set the custom field  "effort" in a story with substack but only on subtask

i need to identify this mistake and send the list in teams of all the story with this error

[Trudy Claspill]

Hello @Vince 

In the title of your post you said that the custom field needs to be set to the "correct value". In the body of your post you don't include that criteria. You mention needing to identify "this mistake" but I'm unclear what part of your example is demonstrating the mistake.

Can you provide more information on that area of your requirements?

Also you say that you only set the field in subtasks, but in the example you show that the value is set at the Story level also. How is the value getting set at the story level?

[Vince]

Hello @Trudy Claspill 

first thanks to answer me

I modify my first post to be more clear , i hope it is my english are not so good

in resume 
if story have subtask effort on story must be 0 ==> the effort is on subtask
if story doesn't have substack the effort is on the story

if these rule are not completed , i need to know witch story are in error
and send the list  in Teams 

[Trudy Claspill]

Thank you for that clarification.

Please feel free to respond in your native language and we can use translation applications to interpret your response and provide our responses in your language.

When do you want the rule to run? For example, do you want it to run once a day to provide this list to you? Or do you want rules that will check each time the effort field is changed in either a Story or a Subtask?

Would it be a mistake to have a Story with 0 for effort when that story has no subtasks?

[Vince]

Hello,
I want to run the rule every Monday and get the list by a teams message
if a story has no subtask the effort = 0 is not a mistake

[Trudy Claspill]

Are there any other criteria you want to apply to identify the issues you want to check? For instance do you want to check issues only in a specific project? Do you care only about Story type issues, or do you care about other issue types that might have subtasks, like Tasks and Bugs? Does it matter what the Status is for the Story, such as do you want this check applied to Story issues that are closed?

[Vince]

hello,
It's for a specific project (NOWD)
i don't care about specific story type
i dont care about the status of the story
thanks for all

[Trudy Claspill]

How many issues (stories and subtasks) do you have in that project? There is a limit to how many issues can be retrieved in a Scheduled automation rule and when using the Lookup Issues action.

Do you have any apps that extend the capabilities of JQL to filter issues, like ScriptRunner or JQL Tricks? The reason I ask is because Jira does not natively have a JQL function to select issues based on whether or not they have subtasks, but those apps can add that function. That would make your rule easier to construct.

I have one additional scenario to ask about. Is the following an error or not?

Story has effort of 3
  subtask has effort of 0

And, lastly, do you consider an effort that has no value at all (blank) to be the same as 0?

[Vince]

hello,
i don't have app to extend jql unfortunately

in our way of work 
usually we have max ten Jira parent with errors with subtack that means 30
the limit is 100  if i'm good it's enough 

in your additionnal scenario, yes it's an error, the effort of 3 must be on the subtask

and yes 0 equals blank for us