topic Modification Timestamp for act_ru_jobs in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/modification-timestamp-for-act-ru-jobs/m-p/157301#M111495 <HTML><HEAD></HEAD><BODY><SPAN>The &lt;em&gt;act_ru_jobs&lt;/em&gt; table is currently (Activiti 5.14) defined without a &lt;strong&gt;CREATED_&lt;/strong&gt; column in contrast to &lt;em&gt;act_ru_task&lt;/em&gt;, which has &lt;strong&gt;CREATE_TIME_&lt;/strong&gt;. or &lt;em&gt;act_ru_event_subscr&lt;/em&gt;, which has &lt;strong&gt;CREATED_&lt;/strong&gt;.</SPAN><BR /><BR /><SPAN>For monitoring and analysis it would be really helpful to have information about the last modification of the job. So a column </SPAN><PRE class="language-none line-numbers"><CODE>`CREATED_` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN> would be really helpful. Are there any plans to add this, or can we just add this column ourselves?</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />CREATE TABLE `act_ru_job` (<BR />&nbsp;&nbsp;&nbsp;`ID_` VARCHAR(64) NOT NULL,<BR />&nbsp;&nbsp;&nbsp;`REV_` INT(11) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`TYPE_` VARCHAR(255) NOT NULL,<BR />&nbsp;&nbsp;&nbsp;`LOCK_EXP_TIME_` TIMESTAMP NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`LOCK_OWNER_` VARCHAR(255) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`EXCLUSIVE_` TINYINT(1) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`EXECUTION_ID_` VARCHAR(64) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`PROCESS_INSTANCE_ID_` VARCHAR(64) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`PROC_DEF_ID_` VARCHAR(64) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`RETRIES_` INT(11) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`EXCEPTION_STACK_ID_` VARCHAR(64) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`EXCEPTION_MSG_` VARCHAR(4000) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`DUEDATE_` TIMESTAMP NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`REPEAT_` VARCHAR(255) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`HANDLER_TYPE_` VARCHAR(255) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;`HANDLER_CFG_` VARCHAR(4000) NULL DEFAULT NULL,<BR />&nbsp;&nbsp;&nbsp;PRIMARY KEY (`ID_`),<BR />&nbsp;&nbsp;&nbsp;INDEX `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),<BR />&nbsp;&nbsp;&nbsp;CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ON UPDATE NO ACTION ON DELETE NO ACTION<BR />)<BR />COLLATE='latin1_swedish_ci'<BR />ENGINE=InnoDB;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>BTW: are there any plans on harmonizing the column names between the tables?</SPAN></BODY></HTML> Tue, 18 Mar 2014 17:04:10 GMT damokles 2014-03-18T17:04:10Z Modification Timestamp for act_ru_jobs https://connect.hyland.com/t5/alfresco-archive/modification-timestamp-for-act-ru-jobs/m-p/157301#M111495 The &lt;em&gt;act_ru_jobs&lt;/em&gt; table is currently (Activiti 5.14) defined without a &lt;strong&gt;CREATED_&lt;/strong&gt; column in contrast to &lt;em&gt;act_ru_task&lt;/em&gt;, which has &lt;strong&gt;CREATE_TIME_&lt;/strong&gt;. or &lt;em&gt;act_ru_event_subscr&lt;/em&gt;, which has &lt;stro Tue, 18 Mar 2014 17:04:10 GMT https://connect.hyland.com/t5/alfresco-archive/modification-timestamp-for-act-ru-jobs/m-p/157301#M111495 damokles 2014-03-18T17:04:10Z Re: Modification Timestamp for act_ru_jobs https://connect.hyland.com/t5/alfresco-archive/modification-timestamp-for-act-ru-jobs/m-p/157302#M111496 <HTML><HEAD></HEAD><BODY><SPAN>Good point, can you raise a JIRA?</SPAN></BODY></HTML> Fri, 21 Mar 2014 16:20:06 GMT https://connect.hyland.com/t5/alfresco-archive/modification-timestamp-for-act-ru-jobs/m-p/157302#M111496 trademak 2014-03-21T16:20:06Z