How to update Jira fields?

Andre de Castro
Contributor
October 16, 2024

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.

3 answers

1 accepted

3 votes
Answer accepted
Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 16, 2024

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.

0 votes
Gregory Kneller
Contributor
November 7, 2024

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.



0 votes
Stephen_Lugton
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 16, 2024

Hi @Andre de Castro 

JQL is a query only language, so no that can't be done natively.

Your options include:

  • Use automation for when a condition happens e.g. a field value changes, an issue is transitioned, manually or on a set schedule
  • Do a filter search using your where condition then bulk update the issues
  • Check whether a marketplace app e.g. Scriptrunner meets your requirements (but there are other options in the marketplace so check those as well)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events