Hi guys.
Is there a way to use JQL to perform an update on Jira fields, similar to the SQL update?
For example UPDATE xxx SET field = [value] WHERE [condition]
Thanks.
No this can't be done.
JQL has no conditional options, you can use automation rules to update issue information based on other available information.
Updating custom field values directly through Jira Query Language (JQL) is not feasible.
While it's technically possible to modify the customfieldvalue
table in the database—specifically the textvalue
, stringvalue
, datevalue
, or numbervalue
columns, depending on the field type — this approach carries significant risks. Not all field types are stored in this table, and direct database modifications can lead to data integrity issues. Therefore, it's crucial to back up the table before making any changes, and reindex Jira will be needed to see the changes in filters and search.
A safer and more efficient method is to use automation tools like ScriptRunner or SIL scripts. These tools allow you to update custom fields programmatically without directly interacting with the database, reducing the risk of errors. For instance, the SIL Engine add-on is a free tool that simplifies this process.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
JQL is a query only language, so no that can't be done natively.
Your options include:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.