Task comments are persisted only in ACT_HI_COMMENT? Not in the runtime tables?

aravindhrs · June 29, 2021, 10:29am

Task comments are persisted only in history tables? Not in the runtime tables?

camunda/camunda-bpm-platform/blob/master/engine/src/main/java/org/camunda/bpm/engine/impl/TaskServiceImpl.java#L363-L365


public Comment getTaskComment(String taskId, String commentId) {
  return commandExecutor.execute(new GetTaskCommentCmd(taskId, commentId));
}

github.com

camunda/camunda-bpm-platform/blob/master/engine/src/main/java/org/camunda/bpm/engine/impl/cmd/GetTaskCommentCmd.java#L42-L49


public Comment execute(CommandContext commandContext) {
  ensureNotNull("taskId", taskId);
  ensureNotNull("commentId", commentId);


  return commandContext
    .getCommentManager()
    .findCommentByTaskIdAndCommentId(taskId, commentId);
}

github.com

camunda/camunda-bpm-platform/blob/master/engine/src/main/java/org/camunda/bpm/engine/impl/persistence/entity/CommentManager.java#L100-L108


public CommentEntity findCommentByTaskIdAndCommentId(String taskId, String commentId) {
  checkHistoryEnabled();


  Map<String, String> parameters = new HashMap<String, String>();
  parameters.put("taskId", taskId);
  parameters.put("id", commentId);


  return (CommentEntity) getDbEntityManager().selectOne("selectCommentByTaskIdAndCommentId", parameters);
}

github.com

camunda/camunda-bpm-platform/blob/master/engine/src/main/resources/org/camunda/bpm/engine/impl/mapping/entity/Comment.xml#L333-L337


<select id="selectCommentByTaskIdAndCommentId" parameterType="map" resultMap="commentResultMap">
  select * from ${prefix}ACT_HI_COMMENT 
  where TASK_ID_ = #{taskId,jdbcType=VARCHAR}
    and ID_ =  #{id,jdbcType=VARCHAR}
</select>

Any updates?