How can I import the approver value from jira issue's history to Jql?

Prakhar Shukla August 18, 2022

Hi All,

I have a use case where I have to take the value from jira ticket history like resolved by, approved by in JQL. However assignee can be different?

I have script runner and hosting on Data center.

 

Thanks in Advance 

1 answer

1 accepted

0 votes
Answer accepted
Tansu Akdeniz
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 18, 2022

Hi @Prakhar Shukla 

In order to see as a column, you can simply add a post-function to the workflow transition and copy these values (user who triggered the action) to newly created custom field (Ex; Resolver, Approver etc).

Also use Approvals = approver("xxx") (For JSM approvals) query if it helps.

Prakhar Shukla August 22, 2022

Hi @Tansu Akdeniz ,

Thank, It's working.

Do you have any idea how to get this transition's date and time in my custom field "Approval Date and time"? I am using Jira software and Automation rule is not possible to apply.

Thanks in advance.

Regards,

Prakhar Shukla

Tansu Akdeniz
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 22, 2022
  • Go to Workflow -> choose the transition where approval is given
  • Click Post-functions
  • Choose Update Issue Custom Field
  • Select your newly created custom field and paste "%%CURRENT_DATETIME%%" as a value.

So, when someone approves, current time will be written to this field.

You are welcome.

Prakhar Shukla August 22, 2022

Thanks again it's working as expected.

Cheers

Suggest an answer

Log in or Sign up to answer