Hey all, I am not able to pull 3 months data that is march april may month report

[Vyshnavi S]

I am not able to pull 3 months of data that is march April and May month reports for ITSD Project that is jira service management project, through JQL or by manual, in JQL though I give resolved>=-90d or resolved >= "2024-03-01" AND resolved <= "2024-06-10", I get only may month and June 10 days data, not getting march april month data. If I try to pull individual data of particular month I am able to get individual months day but not able to get 3 months data at together. Need your help here refer to the screenshot.

[Rilwan Ahmed]

Hi @Vyshnavi S ,

Please user below JQL to get all issues resolved between 01-Mar-2024 and 10-Jun-2024. Make use of braces ( ) properly to filter out the issues. 

Project = ITSD AND (resolved >= '2024-03-01' AND resolved <= '2024-06-10') AND Assignee in (user1, user2, user3)

[Vyshnavi S]

Yet facing the same thing getting may to june10 tickets

[Rilwan Ahmed]

Hi @Vyshnavi S ,

1. You are result 15 page. Did you check page 1 to last ?
   
   
   
2. Please share the full JQL used. 
3. Manually check if there are tickets with the required data. i.e. Tickets resolved in April, June etc.
   Example:  Project = ITSD AND (resolved >= '2024-03-01' AND resolved <= '2024-03-31') AND Assignee in (user1, user2, user3)
   
   

[Vyshnavi S]

yes page 1 has june 10 days ticket later on every pages has may tickets

[Vyshnavi S]

yes  march april month data is there for its project for required assignees,individually if I pull data for particular month its coming but f0r 3months together its not coming

[Vyshnavi S]

CHECK THESE ARE THE TICKETS FOR MARCH AND APRIL WE ARE GETTING WHEN PULLING INDIVIDUALLY

[Duc Thang TRAN]

Hello @Vyshnavi S 

I don't understand your need @Rilwan Ahmed show you a JQL to retrieve all tickets that were resolved from 01 March 2024 to 10 June 2024.

In your next comment,  via your screen that we have more than 1000 tickets, so system work as expected .

If you need to see all tickets resolved in March first, replace order by created desc and add this:
ORDER BY resolved ASC

[Vyshnavi S]

@Duc Thang TRAN I followed your suggetsion I gave order by resolved asc with resolved date march 10 to june 10, U can see I am getting tickets from march to april

[Vyshnavi S]

@Duc Thang TRAN all the tickets displaying are only 2 months tough the query is correct dunno how, may be issue with backend have raised ticket with atlassian

[Vyshnavi S]

@Duc Thang TRAN @Rilwan Ahmed you can check my query 

[Vyshnavi S]

all screenshots belong to one query only, this comment is not allowing me to copy paste jql query so have attached screenshot

[Duc Thang TRAN]

Hello @Vyshnavi S  

Ok, now I see what you mean. Jira Cloud will provide you with only 20 pages of your query results.

So, if you want to see more than 1000 results, you need to either:

• Refine by month as you did in the previous comment.
• Use an add-on like "Jira Cloud for Excel" to extract more than 1000 requests via Excel

[Rilwan Ahmed]

@Vyshnavi S ,

The JQL will display only 1000 results. Seems you have more than 1000 rows. So its better to divide your query month wise.