topic Re: Historic Query on task variable returns empty result in Alfresco Archive

Historic Query on task variable returns empty result

mdond — Wed, 01 Jun 2011 15:58:57 GMT

I am trying to query for some historic tasks with the following query: List<HistoricTaskInstance> tasks = actHistoryService.createHistoricTaskInstanceQuery() .processInstanceId(processId).taskVariableValueEquals("taskType", "specify") .orderByHistoricTaskInstanceEn

Re: Historic Query on task variable returns empty result

ronald_van_kuij — Thu, 02 Jun 2011 21:47:13 GMT

Maarten,

Have a look at the different history levels in the docs. You need 'full' for this afaik…

Re: Historic Query on task variable returns empty result

mdond — Fri, 03 Jun 2011 07:55:59 GMT

Hi Ronald,

thanks a lot. Exactly what I needed.

groetjes,
Maarten

Re: Historic Query on task variable returns empty result

chaoyy — Tue, 05 Jun 2012 13:26:34 GMT

I am trying to query for some historic tasks with the following query:

        List<HistoricTaskInstance> tasks = actHistoryService.createHistoricTaskInstanceQuery()
            .processInstanceId(processId).taskVariableValueEquals("taskType", "specify")
            .orderByHistoricTaskInstanceEndTime().desc().list();

I enabled sql logging to see the generated sql query and it searches for the task variable in the table ACT_HI_DETAIL:

==> Executing: select * from ACT_HI_TASKINST HTI WHERE HTI.PROC_INST_ID_ = ?
and exists ( select HD.ID_ from ACT_HI_DETAIL HD where HD.TYPE_ = 'VariableUpdat
e' and HD.NAME_ = ? and HD.TASK_ID_ = HTI.ID_ and HD.REV_ = (select max(HDM.REV_
) from ACT_HI_DETAIL HDM where HDM.TASK_ID_ = HTI.ID_ and HDM.VAR_TYPE_ = ? and
HDM.NAME_ = ? and HDM.TYPE_ = 'VariableUpdate') and HD.TIME_ = (select max(HDM.T
IME_) from ACT_HI_DETAIL HDM where HDM.TASK_ID_ = HTI.ID_ and HDM.VAR_TYPE_ = ?
and HDM.NAME_ = ? and HDM.TYPE_ = 'VariableUpdate') and HD.VAR_TYPE_ = ? and HD.
TEXT_ = ? ) order by END_TIME_ desc

However this table is completely empty, so no row is returned.

Is there something special to enable writing historic task variables to the table ACT_HI_DETAIL?
If this is the case: Are there performance problems to be expected with writing historic task variables or why is this not enabled by default?

Best regards,
Maarten Donders

How to enabl sql logging to see the generated sql query in Activity?Which file to config?

Re: Historic Query on task variable returns empty result

jbarrez — Wed, 06 Jun 2012 14:05:06 GMT

That is default java.util.Logging. Just add a logging.properties on your classpath. Check the activiti source to find such a file for inspiration.