Page History

...

...


class MySchedTaskJobDelegate implements SchedTaskJobDelegate {
 ...
}

Fix any groovy script used for scripted REST or SQL connector following these best practices:

• Change any multiple assignment like def (one, two) = compositeId.tokenize(',') into
   

  Code Block
  def tokenizedId = compositeId.tokenize('_') def one = tokenizedId[0] def two = tokenizedId[1]

  
  

• Move SQL queries like
  
  

  Code Block
  sql.eachRow("""SELECT * FROM mytable """ + (where == null || where.isEmpty() ? '' : " WHERE " + where) + " ORDER BY codfis ASC LIMIT " + pageSize + " OFFSET " + offset, { result.add([ __UID__ : it.myid, uid : it.myid ...

  into

  Code Block
  sql.eachRow("""SELECT * FROM mytable """ + (where == null || where.isEmpty() ? '' : " WHERE " + where) + " ORDER BY codfis ASC LIMIT " + pageSize + " OFFSET " + offset, {row -> result.add([                            __UID__ : row['myid'], uid : row['myid'],

  
  

• Date formatting should ever be done using a date formatter like

  Code Block
  STD_SDF = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); STD_SDF.format(mydate)