Sheet Sync

JQL Update

Bulk update JIRA issues using a syntax-based command — no manual cell editing required.

The JQL Update feature lets you bulk update JIRA issues using a simple syntax-based command. Instead of editing individual cells, you write an update command that specifies which fields to change and which issues to target using a JQL condition.

JQL Update

JQLU Syntax Example: UPDATE field="value", field = "value" WHERE jql_condition

JQL Update - Result

How it works

  1. Open the JQL Bulk Update panel from the sidebar.
  2. Write a JQLU command specifying the fields to update and a JQL WHERE clause to target specific issues.
  3. Click Execute Update to apply the changes.
  4. A confirmation dialog will show the number of matching issues before the update is applied.

Command examples

UPDATE summary="New Title" WHERE project = "MY-PROJECT" AND status = "To Do"
UPDATE priority="High", assignee="john.doe" WHERE labels = "urgent"
UPDATE status="Done" WHERE sprint in openSprints() AND assignee = currentUser()

Supported fields

You can update most standard and custom JIRA fields:

  • Summary, Status, Assignee, Priority
  • Labels, Components, Fix Versions
  • Sprint, Story Points
  • Custom fields

On this page