Confluence has been updated to version 6.15.9

Page tree
Skip to end of metadata
Go to start of metadata

Introduction 

 Jira Suite Utilities "Clear Field Value" post-function (JSU "Clear Field Value" post-function) does not truncate the records in the Table Grid Editor (TGE). The grid stores the records for each issue in a table in a database. TGE does not store the records in the TGE grid custom field value. Thus, when the JSU "Clear Field Value" post-function clears the TGE custom field value, it does not affect the database records for the grid, and thus does not affect the grid you see in an issue.


Solution

If you want the grid to remove all the records for an issue, we recommend using Script Runner add-on, which executes a script on the desired issue workflow transition.

The script helps to get the Table Grid Editor custom field and sends remove all command to the grid. The script would look something like this:

 
def issue = getTheIssue() // fake function, most probably you would get `issue` like this: `((com.atlassian.jira.issue.IssueManager) com.atlassian.jira.component.ComponentAccessor.getOSGiComponentInstanceOfType (com.atlassian.jira.issue.IssueManager.class)).getIssueObject("KEY-100")`
def tgeCustomField = getTGECustomFieldObject() // fake function, most probably you would get `tgeCustomField` like this: `((com.atlassian.jira.issue.CustomFieldManager) com.atlassian.jira.component.ComponentAccessor.getOSGiComponentInstanceOfType (com.atlassian.jira.issue.CustomFieldManager.class)).getCustomFieldObjectByName("System Components")`
tgeCustomField.getCustomFieldType().updateValue(
  tgeCustomField, issue, 
  "[[\"tempId\",\"u1382690784979\"],[\"all\"]]"
)