How to get resolved by names of approvers in reports?

BKT Helpdesk March 14, 2024

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

1.jpg

 

 

 

1 answer

1 accepted

1 vote
Answer accepted
Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 14, 2024

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 -

2024-03-15 11_51_03-Inventory Management - Issues - Jira.png

BKT Helpdesk March 14, 2024

2.jpg

BKT Helpdesk March 14, 2024

Still unable to retrieve approvers names.

Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 15, 2024

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 March 15, 2024

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

BKT Helpdesk March 15, 2024

2.jpg1.jpg

Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 15, 2024

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 March 15, 2024

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 March 15, 2024

1.jpg

Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 16, 2024

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) -

rule-affected.png

Issue Update via automation -

updated-aff-hardware.png

 

Issue Search via JQL -

affected-hardware.png

 

Hope this helps.

Like BKT Helpdesk likes this
BKT Helpdesk March 16, 2024

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

BKT Helpdesk March 16, 2024

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

BKT Helpdesk March 16, 2024

1.jpg

Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 18, 2024

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.

multiple-approvers.png

BKT Helpdesk March 18, 2024

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

1.jpg

BKT Helpdesk March 18, 2024

Also find results in column affected hardware:

2.jpg

BKT Helpdesk March 18, 2024

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

Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 18, 2024

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

{{initiator.displayName}} 

initiator.png

 

BKT Helpdesk March 19, 2024

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

Like Kishan Sharma likes this
Kishan Sharma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 19, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events