topic HistoricActivityInstanceQuery missing a method in Alfresco Archive

HistoricActivityInstanceQuery missing a method

rafaelduqueestr — Tue, 03 May 2016 14:25:51 GMT

I need to collect end time from a service task. The table who has this information is ACT_HI_ACTINST.I'm trying to use the query API for collect this information, but i'm unable to do what i need. I need something like this: List<HistoricActivityInstance> result = historyService.createH

Re: HistoricActivityInstanceQuery missing a method

martin_grofcik — Wed, 04 May 2016 12:12:43 GMT

Hi,

use native queries http://activiti.org/userguide/index.html#queryAPI, or raw access to the DB

Regards
Martin

Re: HistoricActivityInstanceQuery missing a method

rafaelduqueestr — Wed, 04 May 2016 14:03:49 GMT

I did that.


        List<HistoricActivityInstance> resultado = historyService.createNativeHistoricActivityInstanceQuery()
                .sql(" SELECT atividade.* " +
                     " FROM " + managementService.getTableName(HistoricActivityInstance.class) + " atividade " +
                     " INNER JOIN "+ managementService.getTableName(HistoricVariableInstance.class) +" variavel ON atividade.proc_inst_id_ = variavel.proc_inst_id_ " +
                     " WHERE atividade.act_id_ = #{activityId} " +
                     " AND variavel.name_ = #{variableName} " +
                     " AND variavel.long_ = #{variableValue} " +
                     " ORDER BY atividade.end_time_ DESC ")
                .parameter("variableName", variableName)
                .parameter("variableValue", variableValue)
                .parameter("activityId", activityId)
                .list();