I need a JQL query to pull only 1000 issues from a specific single project.

[Kamal H_ SAGER]

I need a JQL query to pull only 1000 issues from a specific single project.

[Jeff Abbott]

"issue key" ~ "[project key]-1*"
Then repeat for 2, 3, 4, 5, 6, 7, 8 and 9

[Christopher Skoropada _Appsvio_]

Hi @Kamal H_ SAGER 

You can export the filter result into Excel/CSV. In the exported file you will have the first 1000 issues due to export limitations. 

[Rafael Costa]

I guess that have no way to limit return results, but you could limit the date, worked to me. You would need add this flag at end of your JQL: created > endOfDay()

Example:

Return issues from TEST project created at 2 days ago

project = TEST and created > endOfDay(-2d)

 Return issues from TEST project created at 3 weeks ago

project = TEST and created > endOfDay(-3w)

 Return issues from TEST project created at 1 year ago

project = TEST and created > endOfDay(-1y)

You could use various smilar syntaxes too, like:

• startOfDay()
• startOfMonth()
• endOfWeek()
• ...

put the ">" after create word to know all options available.

I hope I've helped!

[Trudy Claspill]

Hello @Kamal H_ SAGER 

Welcome to the community.

JQL does not support letting you specify a number of issues to search for. You specify the criteria that will be used to find matching issues.

Can you provide more information about the problem you are trying to solve?

[Kamal H_ SAGER]

Hey Trudy, 

I am connecting JIRA with Tableau by using Tableau Pro plugin & I got this error:

“This datasource will pull 8830 issues from Jira, but your organization allows to pull only upto 5000 issues. Please adjust the QL to fetch lesser number of issues or contact your Jira administrator to increase the limit“

Is there any way to reduce the number of pulled issues other than filtering! Thank you 

[Trudy Claspill]

Hello @Kamal H_ SAGER 

I have not worked with Tableau before, but I would think the solution would be in the statement from the message "Please adjust the QL".

Is the QL something you set on the Tableau side or in the Tableau Pro plugin that specifies which Jira issues to get? I'm just guessing that Tableau pulls data from Jira, so you have to configure Tableau to request less data by adjusting the QL so it matches to fewer issues.

[Kamal H_ SAGER]

Thank you @Trudy Claspill  I did use the filter to reduce the number of issues, I thought there was a JQL statement that can do the job!