How could i get the task's startdate?

[violet]

We want to get the task's startdate and task's enddate for calculate the task's cost time.

But we can not get the task.starttime.Also we can not
get the time when a user take an ownership of the task.

We used the hsqldb DatabaseManager to connect to the alfresco DB.
And we found the task.starttime in DB ,all the values are "null".

Any help will be really appreciated!

[varsenault]

Actually, we are talking about a task instance and not the task per se. Also the exact table name in the database is "JBPM_TASKINSTANCE" and we are looking at the "JBPM_TASKINSTANCE.START_" column. This column is always null. We expected to be able to have the time at which a task is first opened by someone in that field. How can we do that? And why is the "JBPM_TASKINSTANCE.START_" column always null?

Thanks in advance for your help!

[varsenault]

Since yesterday we made some research on this and we found that JBPM supports a task-start event, but the implementation of this event is not mandatory and it seems it hasn't been done in Alfresco (this is done by calling a task instance's start() method).

Our goal is to record the date at which a task instance is first opened or managed or that its UI is first painted. The task instance creation date is not precise enough for our use. Since the task instance's start() method is never called in Alfresco, we really don't know where to start.

Does anyone knows how to get the task-start event triggered? Thanks!