Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,360,111
Community Members
 
Community Events
168
Community Groups

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

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 Aug 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.

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 Aug 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.

Thanks again it's working as expected.

Cheers

Suggest an answer

Log in or Sign up to answer