Report Query help

Question

I am looking to run a report to gather info from 2020 to current, for any tickets related to 3 keywords AND any cases created by 4 different users.

I tried to find the dates range but it only returned 40 results, which is exponentially low.

project = XX AND created>= "2021/01/01 00:00" AND created<= "2024/08/16 00:00"

any and all help is most appreciated

Trudy P Claspill · Answer

Hello @Mitchell Torres

Welcome to the Atlassian community.

How familiar are you with creating filters? If you are very new to it you may want to take the free, self-paced training to help you learn more about it.

Beginner: https://university.atlassian.com/student/path/1687678-finding-information-with-search-and-filters-in-jira

Intermediate: https://university.atlassian.com/student/path/1124312-intro-to-jql-in-jira-software

And you can find information in the documentation here:

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/

Let's break down your requirement:

I am looking to run a report to gather info from 2020 to current, for any tickets related to 3 keywords AND any cases created by 4 different users.

First: Do you want only the issues that match all three of the requirements; the date requirement, the keyword requirement, and the created by requirement? If not we need a better understanding of how you want these requirements applied:

1. issues that match date, or match keywords, or match created by

2. issues that match date and keywords, or match date and created by

3. ....?

Next let's start with "from 2020 to current":

Are you talking about when the issues were created, when the issues were last updated, or when the issues were resolved?

Using the Basic Search screen you can find the date field of interest:

After selecting that field you will get some additional prompts to help you define the criteria you want to use.

The next part of your requirement is "for any tickets related to 3 keywords"

What field or fields contain those keywords? Do you want issues that have all three keywords, or any one or more of the keywords? When you answer those questions we can suggest how to add that criteria.

The last part of your requirement is "AND any cases created by 4 different users"

Going back to the Basic search you can get the issues that match that thus:

Add the Creator field:

Then start checking off the 4 users of interest. You may have to type in their names to filter the list of users to find them.

When you build your filter in the Basic Search then execute your filter, then use the Switch to JQL option to see what that looks like in JQL.

With the basic search all the issues must match all the criteria you select. If your criteria requires a "this OR that" type of match you'll have to adjust the criteria in the JQL format.

Manoj Kumar Gangwar · Answer

Hi @Mitchell Torres ,

Welcome to the Atlassian community!!

You may try to use something like:

(created >= "2020-01-01" AND 
(summary ~ "keyword1" OR summary ~ "keyword2" OR summary ~ "keyword3" OR 
description ~ "keyword1" OR description ~ "keyword2" OR description ~ "keyword3") AND 
(reporter in (user1, user2, user3, user4)))