How do I add "Requests resolved without an article" to my report

[Vice Pleština]

 I added new filter with "Request Type:ALL" , I tried different things, but nothing. My filter only "catches" Open tasks- Done.
I noticed that I am missing a lot of Done tasks, and they weren't on my report, and then I found them under the  "Requests resolved" default report

[Oday Rafeh · Accepted solution]

Hi @Vice Pleština 

To add "Requests resolved without an article" to your JIRA report, you need to modify your JIRA filter to include the necessary search criteria. Here's how you can do it:

Open JIRA and go to the Issues page.

Click on the "Advanced" search button to open the JIRA Query Language (JQL) editor.

In the JQL editor, enter the following search criteria:

project = <your project name> AND issuetype = <your issue type> AND resolution = <your resolution> AND NOT ("Article Link" is not EMPTY)

Note: Replace <your project name>, <your issue type>, and <your resolution> with the appropriate values for your JIRA instance.

Save your filter with a name, such as "Requests resolved without an article."

Go to the "Reports" section of JIRA and select "Created vs Resolved" report.

Under the "Filter" option, select the filter you just created.

Run the report to see the requests that were resolved without an article.

By using the above JQL search criteria, you will filter all the requests from your project with the specific issue type and resolution status, but excluding the ones that have an "Article Link" field value

[Vice Pleština]

Hi @Oday Rafeh ,

project = "AS" AND  "Requests resolved without an article"   = Done >AND NOT ("Article Link" is not EMPTY)

I am having problems with determining how to categorize the "request resolved without an article" .
 I am sorry for the inconvenience that my inexperience is causing. Everything else is super clear

[Oday Rafeh]

Hi @Vice Pleština 

No problem at all, I'm here to help! In your case, you need to adjust the JQL query to match the specific issue type and resolution you want to filter by. Based on your question, it seems you want to filter issues with a resolution of "Done" and exclude those with an "Article Link" field value. Here's the modified JQL query:

project = "AS" AND resolution = "Done" AND NOT ("Article Link" is not EMPTY)

This query will find all the issues in the "AS" project with a resolution of "Done" and exclude those with an "Article Link" field value.

If you need to further narrow down the results to a specific issue type, add the issuetype parameter to the query:

project = "AS" AND issuetype = "<your issue type>" AND resolution = "Done" AND NOT ("Article Link" is not EMPTY)

Replace your issue type with the name of the issue type you want to filter by.

This query should give you the list of issues resolved as "Done" without an article link in the specified project and issue type.

I hope this will help you :) 

[Vice Pleština]

@Oday Rafeh  I really tried, but still failed. How about I pay you a cup of coffee(paypal/revolut) and you jump in a google meet with me to show me?
My email is vice.plestina@adriagate.com, I am free whenever CET time (08:00- 16:00)

[Asha Goyal]

@Vice Pleština  Please set Resolution as done and then Done tickets will be appearing in report.

Thanks

[Vice Pleština]

Hi Asha, I have very limited knowledge of  JQL, and it pushes me to use it. There is no option in the basic settings?