Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I pull data from a specific queue?

Jordan Meaux March 22, 2023

I am trying to pull data from a queue but the number of requests aren't matching up in the excel sheet.

I have over 2,180 requests in my queue. 

I am going to Filters> Advanced Issue Search. I copy and pasted the JQL from the edit section of my queue to filter the results. But the numbers do not match.

1 answer

0 votes
Paul Wiggers
Community Champion
March 23, 2023

Hello @Jordan Meaux 

Thanks for this question, in order to help you, we need some more information about what you are trying to achieve.

  • How is the JQL looking
  • How many records are shown in the result
  • What information is in the Excel sheet
  • Are their specific results missing from the search results

It sounds like the JQL you are using will need some looking into, but before we can do that, we need to know some more details.

Jordan Meaux March 23, 2023

The JQL is status in ("Open Request", "Review in progress") AND resolution = Unresolved AND labels = Specific_Request . I just copied and pasted what was filtered in the queue


It shows majority of the same tickets in my queue, but it just doesn't show the total 2k amount.  It shows 1,001. I modified the columns from the filter page, but I don't think that would affect my count. I am missing roughly more than 1,000 tickets

Paul Wiggers
Community Champion
March 23, 2023

The JQL is quite restrictive at this moment. Do you have an example of a ticket that you are missing?

Jordan Meaux March 23, 2023

What details from the ticket would you need?

Paul Wiggers
Community Champion
March 23, 2023

Since you are filtering on status, resolution and labels, it would be nice to see a ticket that you are missing that has those specific settings.

Suggest an answer

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

Atlassian Community Events