Working with SQLCustomField Values in Jira Automation

Jira Automation allows teams to streamline repetitive tasks and enhance workflows. When using our SQL custom field, you can easily access and reuse its value in various automation actions such as cloning, creating, or editing issues. This guide walks you through how to reference the SQL custom field value using smart values and apply it within your automation rules to ensure data consistency across your Jira projects.

Example: Clone an Issue and Carry Over the SQL Select List Value

1.Go to Project Settings → Automation → Create Rule → Set the Trigger (“Issue Created” or “Manual Trigger”)

2.New component → New action → Clone issue → more options then add this block

"fields": {
"customfield_10600": "{{issue.customfield_10600}}"
},

where customfield_10600 is the id of the SQL custom field.

Replace customfield_10600 with your actual SQL custom field ID

3.Save and publish the rule.

Once set up, the cloned issues should include the SQL Select List field value as expected.