L3 - Default The processVariableValue filter only woks with history level FULL as it joins on the ACT_HI_DETAIL table (but it should join on the ACT_HI_VARINST table),
YOu can easily check that by adding a process variable to the existing test cases (or add a new one of course 
):
public class HistoricTaskInstanceTest extends PluggableProcessEngineTestCase {
@Deployment
public void testHistoricTaskInstance() throws Exception {
Map<String, Object> variables = new HashMap<String, Object>();
>> variables.put("hallo", "steffen");
String processInstanceId = runtimeService.startProcessInstanceByKey("HistoricTaskInstanceTest", variables).getId();
SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy hh:mm:ss");
// Set priority to non-default value
Task runtimeTask = taskService.createTaskQuery().processInstanceId(processInstanceId).singleResult();
runtimeTask.setPriority(1234);
// Set due-date
Date dueDate = sdf.parse("01/02/2003 04:05:06");
runtimeTask.setDueDate(dueDate);
taskService.saveTask(runtimeTask);
String taskId = runtimeTask.getId();
String taskDefinitionKey = runtimeTask.getTaskDefinitionKey();
HistoricTaskInstance historicTaskInstance = historyService.createHistoricTaskInstanceQuery()
>> .processVariableValueEquals("test", "steffen")
.singleResult();
>> now historicTaskInstance is null
Problem in HistoricTaskInstance.xml:
<foreach collection="variables" index="index" item="var">
and exists (
select HD.ID_
>> from ${prefix}ACT_HI_DETAIL HD
This is the controller panel for Smart Panels app
[CAM-1502] HistoricTasKInstanceQuery with processVariableValue filter fails on history level "AUDIT"
Hi Alexander,
I agree with your findings. It would be great if you could contribute the test case. Instead of changing the engine configuration, I suggest you add the test case either to org.camunda.bpm.engine.test.standalone.history.AuditHistoryTest or add it to HistoricTaskInstanceTest with a condition such that the test case is only executed when the level is AUDIT or higher (see https://github.com/camunda/camunda-bpm-platform/blob/master/engine/src/test/java/org/camunda/bpm/engine/test/api/task/TaskServiceTest.java#L234 for an example).
Cheers,
Thorben
Pull request with test case: https://github.com/camunda/camunda-bpm-platform/pull/161
Hi,
it seems this issue is already corrected, please check file HistoricTaskInstance.xml line 312.
The test case is passing with slight correction:
If needed the mentioned test case can be added to HistoricTaskInstanceTest.java, but in this case the HISTORY_LEVEL_AUDIT should be set for setHistoryLevel in processEngineConfiguration.
Br,
Alexander