How to get resolved by names of approvers in reports?

[BKT Helpdesk]

How to get resolved by names of approvers in reports? Attached screenshot for reference.

[Kishan Sharma · Accepted solution]

Hi @BKT Helpdesk 

Are you trying to list down the names of approvers who have approved the requests ? If yes, you can use below JQL -

"Approvals[Approvals]" = approved()

Example -

[BKT Helpdesk]

[BKT Helpdesk]

Still unable to retrieve approvers names.

[Kishan Sharma]

If you don't mind can you please share a screenshot of a request which is approved by someone? I am interested to know by whom it is approved ? and what is the type of the custom field (eg: user/group picker) 

[BKT Helpdesk]

Attached screenshot as required. I have check by opening multiple column but no result. 

[BKT Helpdesk]

[Kishan Sharma]

Thank you for the screenshots @BKT Helpdesk, can you please confirm the field types of "Approvers" and "Issue Solver" custom field. I am currently attempting to validate whether we are encountering the scenario described in this discussion thread.

[BKT Helpdesk]

Attached screenshot with Approvers and Issue solver custom fields. It is showing all approvers and issue solver. Actual issue solver/approver not showing. Require only approver name to reflect in this.

[BKT Helpdesk]

[Kishan Sharma]

Hi @BKT Helpdesk Thank you for your patience. It appears that the approvers name is not captured by Jira in any field.

You'll need to set up a new custom field or utilize an existing text field and fill it through an automation rule when an issue is approved. Please refer steps on this thread ,even I tried it and it works well.

Automation Rule (I used Affected hardware field for testing) -

Issue Update via automation -

Issue Search via JQL -

Hope this helps.

[BKT Helpdesk]

Yes this fixed for me. Thank you for your great support @Kishan Sharma . 

[BKT Helpdesk]

But what if we have multiple approvers? All approvers are reflecting if any of the approver is approving the tickets.

[BKT Helpdesk]

[Kishan Sharma]

Hi @BKT Helpdesk Through the automation rule, are you updating the same field or any other ? Can you please share a screenshot of the rule details ?
In my example, I used a separate field (Affected hardware), and it only captures the person's name who approved the request.

[BKT Helpdesk]

Check this out rule and also done changes described by you:

[BKT Helpdesk]

Also find results in column affected hardware:

[BKT Helpdesk]

Need the name of the approver only from the list. Not to reflect all the names in the report.

[Kishan Sharma]

You will have to use below smart value to set the value for the chosen field.

{{initiator.displayName}} 

[BKT Helpdesk]

Thank you for your great support. Able to retrieve all approvers name.

[Kishan Sharma]

Great, glad to help @BKT Helpdesk ! Please consider marking the answer as accepted to assist other members who may have similar questions.