Table grid synchronization with Exalate

Originally asked by Alberto Carrani on 09 November 2021 (original question)


Hi Community,
we are in the need of synchronizing two JIRA Data center instances on premise with Exalatethat have both installed table grid plug in.
We successfully followed the guide from Exalate KB (https://docs.idalko.com/exalate/display/ED/How+to+sync+Table+Grid+Editor+data), but we have a question.
Given that the “tgeGridDataManager.addRows” method requires the issue id parameter, it can’t be used for the first sync: is there a way to automatically add the grid data without the need of asking the user to perform an additional action on the source ticket (such as manually execute a transition)?
Please consider that on both platforms we have Scriptrunner installed.


Answer by Daniel Carvajal on 09 November 2021

Hi Alberto Carrani

We came up with the following approach, the epic.groovy script contains a “CreateIssue” method that would be useful for us, so the way to implement this is:

  1. Download and add the epic.groovy script to your environment: https://docs.idalko.com/exalate/x/oAF1Aw
  2. Add the following code to your script:
Epic.CreateIssue.create(
                    replica,
                    issue,
                    syncRequest,
                    nodeHelper,
                    issueBeforeScript,
                    remoteReplica,
                    traces,
                    blobMetadataList) {  
 Long issueId=issue.id as Long
 tgeGridDataManager.addRows(issueId, ...)
                return null
            } 
  

Notes:

You need to add the parameters necessary on this line: tgeGridDataManager.addRows(issueId, …)

You can add this at any part of the script, it doesn’t need to be inside the “if firstSync()” clause.

Give it a try and let us know the outcome.

Cheers,

Daniel


Comments:

Alberto Carrani commented on 10 November 2021

Hi Daniel Carvajal ,

I followed your instructions by adding Epic.groovy script and using the method you suggested and it worked like a charm.

Many thanks,

Alberto