---
title: "Use JQL to find issues to update"
canonical: "https://support.appfire.com/space/CSOT/68747816/Use%20JQL%20to%20find%20issues%20to%20update"
format: markdown
---
> Macro (aura-html)
# Summary
When transitioning an issue, you may need to update other issues with information from the issue being transitioned. Any issue(s) that can be found by a JQL query is easy to update. More than one issue can be updated with a single post function provided the update that is needed is the same for all issues, otherwise, multiple post functions would need to be used.
# Steps
The following steps demonstrate how to configure Create on Transition for Jira to update a bunch of issues with the use of the JQL feature:
| | | |
| --- | --- | --- |
|  | ## Step 1
As a Jira Administrator or Workflow Administrator:
1. Click the **Cog** icon to open the *Settings* menu and select **Issues**
2. Click **Workflows**
3. Navigate to your workflow and edit your workflow to create a draft version
4. Select the transition
5. Select the *Post Functions* tab.
6. Click* Add post function*
7. Select *Update issues (Bob Swift)* post function and add | ![image]() |
|  | ## Step 2
Within the Issue Fields screen:
1. Select the *Detailed Fields* tab
2. Add the JQL result to the **Issues to update** field
1. **%jql_result%** - comma-separated list of issue keys matching the query
2. **%jql_result_1%** - first issue matching the query
> ⚠️ 1. Determine if you want all issues matching the JQL or just the first one.
> ⚠️ 2. Select the appropriate replacement JQL based replacement variable. | |
|  | ## Step 3
Define the JQL used that retrieves the issues that need to be updated.
1. Select the *Conditions & Configuration* tab.
2. Enter a JQL query either by entering the query in the *JQL query* field or availing [Use JQL editor](https://appfire.atlassian.net/wiki/spaces/CSOT/pages/68748570/Optional+rules+-+Cloud#Configuration).
3. (optional) To validate your query, click *Use JQL Editor.* You can view the list of issues and also be able to modify your query as needed.
> ⚠️ - If you are using substitution variables, make sure values with blanks are quoted.
> ⚠️ - Use an ORDER BY clause if it is important to find only the first issue satisfying the query. | |
|  | ## Step 4
1. Ensure to publish your workflow. It is always recommended to save a backup of the previous workflow when prompted.
2. Run a test scenario by navigating to an issue and doing the transition.
> ⚠️ - JQL errors are logged. Look for error messages in the app [configuration](https://appfire.atlassian.net/wiki/x/fAcZB). **Note:** This is the most common cause for not getting the expected updates.
> ⚠️ - Remember, the JQL query runs under the user's permission unless you are using **Acting user** support. | |