The time when the Activiti workflow was last annotated. The activiti Workflow

The time when the Activiti workflow was last annotated. The activiti Workflow

Sometimes we may encounter such a requirement in workflow development, that is, the approval process has been completed. Maybe we still need to modify the results of the business table, and we need a time period, such: can be modified within 5 days

At this time, we need to get our last approval time. We can query the time through the following SQL statement.

Select max (COMM. TIME _) FROM ACT_HI_COMMENT comm where comm. PROC_INST_ID _ IN (select ins. PROC_INST_ID _ FROM ACT_HI_PROCINST ins where ins. BUSINESS_KEY _ = ?)

? Indicates the business key.