nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get property from parent level when checking condition in child level?

Gokaraju gopi

{{#webResponse.body.values}}{{#items}}{#if(equals(fromString, "In Progress"))}}{{/}}{{/}}{{/}}

How to get created property from values when fromString property is matched inside items?

Use example response from /rest/api/3/issue/{issueKey}/changelog api

Accepted answers

Bill Sheboy

Hi @Gokaraju gopi

The suggestion you got from the other tool is not correct; there is a limitation for the long-format of smart values iterators: once inside the iterator, only data from that scope and lower is visible.

For your scenario, the created attribute cannot be "seen" once inside the {{#items}} ... {{/}} iterator as it filters to that scope.

One workaround is using the inline iterator and the match() function rather than a nested, long-format iterator. For example:

{{#webResponse.body.values}}
  {{#if(items.toString.match("^(In Progress)").size.gt(0))}}
    {{created}}
  {{/}}
{{/}}

Please note this could return multiple created values for the changelog entries, so decide how you want to handle that...such as adding delimiters and parsing the results.

Also, it appears you are doing this for the Status field entries in the changelog, so perhaps instead use the Bulk Fetch Changelogs endpoint as that allows filtering by the field(s):

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-changelog-bulkfetch-post

Kind regards,
Bill

All comments

Gokaraju gopi

Got following suggestion from Handlerbars but it was not working in jira smart values in automations

<span>{{#webResponse.body.values}}
  {{#items}}
    {{#if(equals(toString, "In Progress"))}}
      {{../created}}
    {{/}}
  {{/}}
{{/}}</span>

Bill Sheboy

Hi @Gokaraju gopi

For your scenario, the created attribute cannot be "seen" once inside the {{#items}} ... {{/}} iterator as it filters to that scope.

One workaround is using the inline iterator and the match() function rather than a nested, long-format iterator. For example:

{{#webResponse.body.values}}
  {{#if(items.toString.match("^(In Progress)").size.gt(0))}}
    {{created}}
  {{/}}
{{/}}

Please note this could return multiple created values for the changelog entries, so decide how you want to handle that...such as adding delimiters and parsing the results.

Also, it appears you are doing this for the Status field entries in the changelog, so perhaps instead use the Bulk Fetch Changelogs endpoint as that allows filtering by the field(s):

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-changelog-bulkfetch-post

Kind regards,
Bill

Gokaraju gopi

Hi @Bill Sheboy ,

This API helped me to improve my logic. Thanks for sharing it. I had one more question on the created date. The bulk fetch changelog api was returning created": 1689316751665.

Below is example response

{

"id": "11054",

"created": 1689316751665,

"items": [

{

"field": "status",

"fieldtype": "jira",

"fieldId": "status",

"from": "10002",

"fromString": "Done",

"to": "3",

"toString": "In Progress"

}

]

How can I convert that to jira dates so that I can update the same in date field? Tried all functions from jira dates but that did not worked https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

Bill Sheboy

Hi @Gokaraju gopi

That endpoint returns the UNIX timestamp (from the start of day on 1 Jan 1970). And thus the number could be added to that date / time to get the value.

When you expect the changelog to have lots of entries and the Status change is not in the first 100 of them, use this approach with the bulk changelog endpoint.

When you believe there are fewer changelog entries, another approach is continuing to use your original issue get endpoint with the changelog parameter and add the filter for the Status field:

{{#webResponse.body.values}}
  {{#if(and(items.toString.match("^(In Progress)").size.gt(0), items.field.match("^(status)").size.gt(0)))}}
    {{created}}
  {{/}}
{{/}}

Gokaraju gopi

Its working now with

{{apochDate.toDate.plusMillis(firstInProgressDate.asNumber)}}

Where

apochDate = {{now.withYear(1970).withMonth(1).withDayOfMonth(1).withHour(0).withMinute(0).withSecond(0).withMillis(0).convertToTimeZone("UTC")}}

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

automation

jira-automation