Read and Write TGNG data (Table Grid Next Generation)

Question

Hello, I am attempting to read contents of a table grid next generation custom field from a current issue and copy it's contents to the same table grid field in a create new issue form. Unsure how this gets done, the challenge here seems to be targeting a new form to write the grid data. Here is some dirty code we have been playing with. import com.atlassian.jira.component.ComponentAccessor; import com.atlassian.jira.issue.CustomFieldManager; import com.atlassian.jira.user.ApplicationUser; import com.atlassian.plugin.PluginAccessor; import com.atlassian.jira.issue.fields.CustomField; import com.atlassian.jira.issue.Issue; import com.atlassian.jira.issue.IssueManager; import com.idalko.tgng.jira.server.api.* import static com.atlassian.jira.issue.IssueFieldConstants.*; IssueManager issueManager = ComponentAccessor.getOSGiComponentInstanceOfType(IssueManager.class) //Issue issue = issueManager.getIssueObject(issue.key); //actual use //Long issueId = issue.getId() CustomFieldManager customFieldManager = ComponentAccessor.getOSGiComponentInstanceOfType(CustomFieldManager.class); if (getBehaviourContextId() == "SPR") { getFieldById("project-field").setReadOnly(true) getFieldById("issuetype-field").setReadOnly(true) def contextIssue = issueManager.getIssueObject(getContextIssueId()) def contextIssueId = contextIssue.getId() //Get Company Value .................... def CompanyCF = customFieldManager.getCustomFieldObject("customfield_11002")//Company def contextCompanyCF = contextIssue.getCustomFieldValue(CompanyCF) as String def CompanyCFconfig = CompanyCF.getRelevantConfig(contextIssue) def optionsManager = ComponentAccessor.getOptionsManager() def options1 = optionsManager.getOptions(CompanyCFconfig) def optionToSelect = options1.find { it.value == contextCompanyCF } //Get Items grid....................................... // Get TGNG custom field id CustomField tgngCustomField = customFieldManager.getCustomFieldObjectsByName("Items")[0] Long tgngCustomFieldId = tgngCustomField.getIdAsLong() ApplicationUser user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser() PluginAccessor pluginAccessor = ComponentAccessor.getPluginAccessor() Class apiServiceClass = pluginAccessor.getClassLoader().loadClass("com.idalko.tgng.jira.server.api.GridService") def gridService = ComponentAccessor.getOSGiComponentInstanceOfType(apiServiceClass) // Read field data def fieldData = gridService.readFieldData(contextIssueId, tgngCustomFieldId, user, null) def gridRows = fieldData.getRows() //def fieldData2 = "" /*StringBuilder result = new StringBuilder() for (row in gridRows) { def columns = row.getColumns() result.append("Qty: ${columns.get("qty")}, ") result.append("Item#/Description: ${columns.get("vendoritemnumber")}, ") result.append("GL Account: ${columns.get("glaccountno")}, ") result.append("UoM: ${columns.get("uom")}; ") result.append("Unit Price: ${columns.get("unitprice")};
")*/ //fieldData2 = gridService.addRows(null, tgngCustomFieldId, user, [ //["qty": "2", "vendoritemnumber": "123456", "glaccountno": "654321", "uom": "Each", "unitprice": "2.50"] //]) //} //Write Form Values.......... getFieldById("summary").setFormValue("${contextIssue.summary}").setReadOnly(true)//Summary getFieldById("issuelinks-linktype").setFormValue("Creates").setReadOnly(true)//link Type getFieldById("issuelinks-issues").setFormValue(contextIssue.key).setReadOnly(true) getFieldById("customfield_11002").setFormValue(optionToSelect.optionId).setReadOnly(true)//Company getFieldById("customfield_11009").setFormValue(contextIssue.getCustomFieldValue(tgngCustomField)) }

jeff singler · Answer

the view we were using was actually a script fragment for creating a constrained issue so we can have it show up in a specific spot.  Then from there it would copy data fields from the current issue into the fields on the form pop up.  We used a behavior to accomplish this but we are stuck with the table grid field.  we can get other fields to come in but just not the table grid values.

Adrienne Bolger · Answer

Where is the context coming from in your case? There are multiple example in this forum of script runner scripts for "cloning" an issue, rather than just clicking the "create issue" button in JIRA, that might be closer to what you want. (Here is a Service desk example from the documentation: https://scriptrunner.adaptavist.com/5.6.8/jira/recipes/workflow/servicedesk/clone-issue-sd.html)

Alternately if this is from a custom post function or workflow action you have added, I believe it is possible to get your contextual issue from specific reserved keywords from script runner (e.g. "event.issue" is available for all issue update events, etc.)

Script Runner also has the concept of an "initialiser" function: https://scriptrunner.adaptavist.com/5.5.8/jira/recipes/behaviours/setting-default-fields.html

Which is what Adaptavist recommends for setting field defaults on create. It looks like initializers offer a default 'issueContext' variable which might contain what you want if someone has clicked on a custom 'Clone this Issue' type action rather than the generic 'Create' button from a top level menu.

jeff singler · Answer

More like number 2.  From a create new form window, I need the values from the table grid in the context of the issue already open to populate into the table grid on the new issue form.  Or more accurately we need to copy values from the original grid into the new grid.  Trouble is I seem to be needing to target an issue to do that but there is none existing yet as it is a new form window.