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.
Hi @Andre de Castro
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.
JQL is a query only language, so no that can't be done natively.
Your options include:
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.
customfieldvalue
textvalue
stringvalue
datevalue
numbervalue
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.
It looks like you're new here. Sign in or register to get started.
