i want to fetch all issues that have a transtion to a given status.
The basic way would be searching all issues that a re not in the target status. and then get the transitions per issue and filter to any, that include a transtion to status X.
This is slow and many api calls. What other ideas do you have?
I dont have access to automation
Project + Issue Type are associated with a Workflow, which contains transitions.
Use Bulk Get Workflows to get the workflows for the Projects + Issue Types you are interested in:
https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-workflows/#api-rest-api-3-workflows-post
Analyze the “transitions” returned to see if they contain your target transitions.
Then you know which projects + issue types to filter for in your JQL. Optionally exclude issues that already have the target status.