The following JQL fails:
project = <projectId> AND id >= 1 ORDER BY id DESC
Issue does not exist or you do not have permission to see it.
Do not understand why it fails - I do not need to access issue
id = 1, I just want to find all issues in the project
id greater then
1 (or any other number). Is there any way how to compare issue id for non-existing id?
Use case: I want to use
id for paging instead of
startAt because such paging is more robust to concurrent changes when I need to process all issues in the project. It works this way:
- read 100 issues
project = <projectId> ORDER BY id DESC
- process the issues
- read next 100 issues:
project = <projectId> AND id >= <lastIssueId> ORDER BY id DESCand go to processing (2.) again.
It works well unless the last issue from the page is deleted concurrently, so the
<lastIssueId> does not exists, then it fails with the above error.