• Home
• io.nflow
• nflow-engine
• 7.2.0
• source code
• sqlserver.update.ddl.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

scripts.db.update-5.6.0-x.sqlserver.update.ddl.sql Maven / Gradle / Ivy

alter table nflow_workflow add started datetimeoffset(3);
alter table nflow_archive_workflow add started datetimeoffset(3);

go

update w set
  w.started = a.started,
  w.modified = w.modified
from
  nflow_workflow w,
  (select workflow_id, min(execution_start) as started from nflow_workflow_action group by workflow_id) a
where w.id = a.workflow_id;

update w set
  w.started = a.started,
  w.modified = w.modified
from
  nflow_archive_workflow w,
  (select workflow_id, min(execution_start) as started from nflow_archive_workflow_action group by workflow_id) a
where w.id = a.workflow_id;