nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL

Kamil Askerov_bo3jkx

Hi. How to write JQL for projects , where issues count more than 1000? I wrote JQL and see only 1000 issues. I whant to migrate information from 1 project to other. I use the deep clone application. But cant migrate more than 1000 issues. I thinking to write JQL for every 1000 issues. And if it resolve the problem - how I can select first 1000 then next 1000 else in JQL? In SQL (Oracle) f e have rowid <=1000.

Accepted answers

All comments

Ste Wright

Hi @Kamil Askerov

JQL (and bulk move capabilities) are limited to 1000 results at a time.

If you're moving the issues though - couldn't you...

Search/move 1000 issues, based on Project Key
Then, search for the next 1000 - as the Project Key for the first batch will now be different, and shouldn't reappear in the search results

...?

Ste

Kamil Askerov_bo3jkx

@Ste Wright

"Search/move 1000 issues, based on Project Key

"Then, search for the next 1000 - as the Project Key for the first batch will now be different, and shouldn't reappear in the search results"

I dont know how to do this. I use JQL for migrate. And dont know how to select first 1000 then next 1000 and then next 1000...

Ste Wright

Hi @Kamil Askerov

You'd need to do in stages - for example...

Project A has 5000 issues
So, I would...
- Search for issues in Project A - eg. project = "Project A"
- Bulk move the first 1000 results
- Re-search for project = "Project A" - there will now be 4000 results
- Bulk move another 1000 results
- Continue with this until all 5000 issues are moved (in 5 separate batches)

Ste

Kamil Askerov_bo3jkx

@Ste Wright I dont move that issues , i copying them. Therefore my issues always stay at that project. You algorithm is interesting but thinking not work for me.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud