How to extract report for rejected requests and who reject it ?

[Mohamed Saad Taha]

HI Expert,

I am using data centre edition of Jira service management, and I want to extract report for rejected requests and who reject it 

[Danut M _StonikByte_]

Hi @Mohamed Saad Taha,

Is this question in the context of the approvals feature specific to Jira Service Management?

If yes, you can run a JQL like this to obtain the tickets that were declined:

Approvals = declined() 

Keep in mind this query will return not only issues that are currently rejected, but also the ones that were rejected at least once in their lifecycle and are now actually approved.

Unfortunately in the search results does not seem to be possible to see who declined. There is a "Approvers" column, but that displays all the approvers of the issue, not only who rejected... Also, I am not aware of a native Jira report or gadget that is capable to display this info. 

A potential solution would be to search on Atlassian Marketplace for an app (plugin) that offers such report or gadget. 

In case you want to try a plugin, our Great Gadgets app offers a Pivot Table & Pivot Chart gadget that allows you to display the persons who declined the ticket.

This example is for the same JQL in the example above. On the Approvals - Declined column it will display the person who makes the ticket to be rejected: CSP-11 is declined by Dorothy Grey. 

To display this info the gadget should be configured like this:

 

Hope this helps. 

Danut. 

[Mohamed Saad Taha]

@Danut M _StonikByte_ thanks a lot for your reply it is perfect, but I want to find away without adding more plugins

[Danut M _StonikByte_]

Hi @Mohamed Saad Taha, 

Rejected requests: Approvals = declined() 

Who rejected? I don't see a way of doing this :(

Danut.

[Fabio Racobaldo _Herzum_]

Hi @Mohamed Saad Taha

it depends from your workflow. Do you have a specific status for rejected tickets or a specific resolution? Do you store user that rejected ticket on a specific custom field?

In my opinion you could setup a JQL (or a specific queue) in order to retrieve those tickets.

Please let me know,

Fabio

[Mohamed Saad Taha]

HI @Fabio Racobaldo _Herzum_ ,

thanks a lot for your reply, Yes I have specific status and resolution but i don't store the name to store the user who reject the request 

[Fabio Racobaldo _Herzum_]

You can improve your workflow adding a post function that store in a specific user custom field user that perform reject transtion (if you have a specific one).

Ciao,

Fabio

[Mohamed Saad Taha]

@Fabio Racobaldo _Herzum_  can you Please support me with example for the post function 

[Fabio Racobaldo _Herzum_]

hey @Mohamed Saad Taha ,

please create a user-picker custom field (Rejected By), then create a specific transition to rejected with two post functions. The first one (Update Issue Field) should automatically set the resolution as 'Rejected' and the second one (Update Issue Custom Field) should populate custom field Rejected By with %%CURRENT_USER%% value.

After doing that you will have information about user that performed that action.

Hope this helps,

Fabio

[Mohamed Saad Taha]

@Fabio Racobaldo _Herzum_ 

thanks alot I used workflow majic box to update custom files but it is not ready the %%CURRENT_USER%% even i try {CURRENT_USER} or {{CURRENT_USER}}

not working 

[Fabio Racobaldo _Herzum_]

Hey @Mohamed Saad Taha , why not Update Issue Custom Field post function? I don't know workflow magjic box app.

[Mohamed Saad Taha]

@Fabio Racobaldo _Herzum_  Magic box is addon provide this post function there is no OOB post function do this functionality 

[Fabio Racobaldo _Herzum_]

@Mohamed Saad Taha Update Issue Custom Field or Update Work item Custom field is a built in post function provided by JIRA (https://support.atlassian.com/jira-cloud-administration/docs/configure-advanced-issue-workflows/)