Java Code Examples for org.activiti.engine.runtime.ProcessInstanceQuery#list()

The following examples show how to use org.activiti.engine.runtime.ProcessInstanceQuery#list() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 6 votes vote down vote up
@Deployment(resources = { "org/activiti/engine/test/api/oneTaskProcess.bpmn20.xml" })
public void testQueryAllVariableTypes() throws Exception {
  Map<String, Object> vars = new HashMap<String, Object>();
  vars.put("nullVar", null);
  vars.put("stringVar", "string");
  vars.put("longVar", 10L);
  vars.put("doubleVar", 1.2);
  vars.put("integerVar", 1234);
  vars.put("booleanVar", true);
  vars.put("shortVar", (short) 123);

  ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  ProcessInstanceQuery query = runtimeService.createProcessInstanceQuery().variableValueEquals("nullVar", null).variableValueEquals("stringVar", "string").variableValueEquals("longVar", 10L)
      .variableValueEquals("doubleVar", 1.2).variableValueEquals("integerVar", 1234).variableValueEquals("booleanVar", true).variableValueEquals("shortVar", (short) 123);

  List<ProcessInstance> processInstances = query.list();
  assertNotNull(processInstances);
  assertEquals(1, processInstances.size());
  assertEquals(processInstance.getId(), processInstances.get(0).getId());

  runtimeService.deleteProcessInstance(processInstance.getId(), "test");
}
 
Example 2
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 6 votes vote down vote up
public void testQueryByProcessInstanceIds() {
  Set<String> processInstanceIds = new HashSet<String>(this.processInstanceIds);

  // start an instance that will not be part of the query
  runtimeService.startProcessInstanceByKey("oneTaskProcess2", "2");

  ProcessInstanceQuery processInstanceQuery = runtimeService.createProcessInstanceQuery().processInstanceIds(processInstanceIds);
  assertEquals(5, processInstanceQuery.count());

  List<ProcessInstance> processInstances = processInstanceQuery.list();
  assertNotNull(processInstances);
  assertEquals(5, processInstances.size());

  for (ProcessInstance processInstance : processInstances) {
    assertTrue(processInstanceIds.contains(processInstance.getId()));
  }
}
 
Example 3
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 6 votes vote down vote up
public void testQueryByProcessInstanceIds() {
  Set<String> processInstanceIds = new HashSet<String>(this.processInstanceIds);

  // start an instance that will not be part of the query
  runtimeService.startProcessInstanceByKey("oneTaskProcess2", "2");
 
  ProcessInstanceQuery processInstanceQuery = runtimeService.createProcessInstanceQuery().processInstanceIds(processInstanceIds);
  assertEquals(5, processInstanceQuery.count());
  
  List<ProcessInstance> processInstances = processInstanceQuery.list();
  assertNotNull(processInstances);
  assertEquals(5, processInstances.size());
  
  for (ProcessInstance processInstance : processInstances) {
    assertTrue(processInstanceIds.contains(processInstance.getId()));
  }
}
 
Example 4
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 5 votes vote down vote up
@Deployment(resources={
  "org/activiti5/engine/test/api/oneTaskProcess.bpmn20.xml"})
public void testQueryAllVariableTypes() throws Exception {
  Map<String, Object> vars = new HashMap<String, Object>();
  vars.put("nullVar", null);
  vars.put("stringVar", "string");
  vars.put("longVar", 10L);
  vars.put("doubleVar", 1.2);
  vars.put("integerVar", 1234);
  vars.put("booleanVar", true);
  vars.put("shortVar", (short) 123);
  
  ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  ProcessInstanceQuery query = runtimeService.createProcessInstanceQuery()
    .variableValueEquals("nullVar", null)
    .variableValueEquals("stringVar", "string")
    .variableValueEquals("longVar", 10L)
    .variableValueEquals("doubleVar", 1.2)
    .variableValueEquals("integerVar", 1234)
    .variableValueEquals("booleanVar", true)
    .variableValueEquals("shortVar", (short) 123);
  
  List<ProcessInstance> processInstances = query.list();
  assertNotNull(processInstances);
  assertEquals(1, processInstances.size());
  assertEquals(processInstance.getId(), processInstances.get(0).getId());

  runtimeService.deleteProcessInstance(processInstance.getId(), "test");
}
 
Example 5
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 4 votes vote down vote up
@Deployment(resources = { "org/activiti/engine/test/api/oneTaskProcess.bpmn20.xml" })
public void testQueryStringVariable() {
  Map<String, Object> vars = new HashMap<String, Object>();
  vars.put("stringVar", "abcdef");
  ProcessInstance processInstance1 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  vars = new HashMap<String, Object>();
  vars.put("stringVar", "abcdef");
  vars.put("stringVar2", "ghijkl");
  ProcessInstance processInstance2 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  vars = new HashMap<String, Object>();
  vars.put("stringVar", "azerty");
  ProcessInstance processInstance3 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  // Test EQUAL on single string variable, should result in 2 matches
  ProcessInstanceQuery query = runtimeService.createProcessInstanceQuery().variableValueEquals("stringVar", "abcdef");
  List<ProcessInstance> processInstances = query.list();
  assertNotNull(processInstances);
  assertEquals(2, processInstances.size());

  // Test EQUAL on two string variables, should result in single match
  query = runtimeService.createProcessInstanceQuery().variableValueEquals("stringVar", "abcdef").variableValueEquals("stringVar2", "ghijkl");
  ProcessInstance resultInstance = query.singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance2.getId(), resultInstance.getId());

  // Test NOT_EQUAL, should return only 1 resultInstance
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueNotEquals("stringVar", "abcdef").singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  // Test GREATER_THAN, should return only matching 'azerty'
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThan("stringVar", "abcdef").singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThan("stringVar", "z").singleResult();
  assertNull(resultInstance);

  // Test GREATER_THAN_OR_EQUAL, should return 3 results
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("stringVar", "abcdef").count());
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("stringVar", "z").count());

  // Test LESS_THAN, should return 2 results
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThan("stringVar", "abcdeg").list();
  assertEquals(2, processInstances.size());
  List<String> expecedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  List<String> ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expecedIds);
  assertTrue(ids.isEmpty());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThan("stringVar", "abcdef").count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("stringVar", "z").count());

  // Test LESS_THAN_OR_EQUAL
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("stringVar", "abcdef").list();
  assertEquals(2, processInstances.size());
  expecedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expecedIds);
  assertTrue(ids.isEmpty());

  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("stringVar", "z").count());
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("stringVar", "aa").count());

  // Test LIKE
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueLike("stringVar", "azert%").singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueLike("stringVar", "%y").singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueLike("stringVar", "%zer%").singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueLike("stringVar", "a%").count());
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLike("stringVar", "%x%").count());

  // Test value-only matching
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals("azerty").singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  processInstances = runtimeService.createProcessInstanceQuery().variableValueEquals("abcdef").list();
  assertEquals(2, processInstances.size());
  expecedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expecedIds);
  assertTrue(ids.isEmpty());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals("notmatchinganyvalues").singleResult();
  assertNull(resultInstance);

  runtimeService.deleteProcessInstance(processInstance1.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance2.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance3.getId(), "test");
}
 
Example 6
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 4 votes vote down vote up
@Deployment(resources = { "org/activiti/engine/test/api/oneTaskProcess.bpmn20.xml" })
public void testQueryLongVariable() {
  Map<String, Object> vars = new HashMap<String, Object>();
  vars.put("longVar", 12345L);
  ProcessInstance processInstance1 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  vars = new HashMap<String, Object>();
  vars.put("longVar", 12345L);
  vars.put("longVar2", 67890L);
  ProcessInstance processInstance2 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  vars = new HashMap<String, Object>();
  vars.put("longVar", 55555L);
  ProcessInstance processInstance3 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  // Query on single long variable, should result in 2 matches
  ProcessInstanceQuery query = runtimeService.createProcessInstanceQuery().variableValueEquals("longVar", 12345L);
  List<ProcessInstance> processInstances = query.list();
  assertNotNull(processInstances);
  assertEquals(2, processInstances.size());

  // Query on two long variables, should result in single match
  query = runtimeService.createProcessInstanceQuery().variableValueEquals("longVar", 12345L).variableValueEquals("longVar2", 67890L);
  ProcessInstance resultInstance = query.singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance2.getId(), resultInstance.getId());

  // Query with unexisting variable value
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals("longVar", 999L).singleResult();
  assertNull(resultInstance);

  // Test NOT_EQUALS
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueNotEquals("longVar", 12345L).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  // Test GREATER_THAN
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThan("longVar", 44444L).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("longVar", 55555L).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("longVar", 1L).count());

  // Test GREATER_THAN_OR_EQUAL
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("longVar", 44444L).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("longVar", 55555L).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("longVar", 1L).count());

  // Test LESS_THAN
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThan("longVar", 55555L).list();
  assertEquals(2, processInstances.size());

  List<String> expectedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  List<String> ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expectedIds);
  assertTrue(ids.isEmpty());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThan("longVar", 12345L).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueLessThan("longVar", 66666L).count());

  // Test LESS_THAN_OR_EQUAL
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("longVar", 55555L).list();
  assertEquals(3, processInstances.size());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("longVar", 12344L).count());

  // Test value-only matching
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(55555L).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  processInstances = runtimeService.createProcessInstanceQuery().variableValueEquals(12345L).list();
  assertEquals(2, processInstances.size());
  expectedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expectedIds);
  assertTrue(ids.isEmpty());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(999L).singleResult();
  assertNull(resultInstance);

  runtimeService.deleteProcessInstance(processInstance1.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance2.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance3.getId(), "test");
}
 
Example 7
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 4 votes vote down vote up
@Deployment(resources = { "org/activiti/engine/test/api/oneTaskProcess.bpmn20.xml" })
public void testQueryDoubleVariable() {
  Map<String, Object> vars = new HashMap<String, Object>();
  vars.put("doubleVar", 12345.6789);
  ProcessInstance processInstance1 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  vars = new HashMap<String, Object>();
  vars.put("doubleVar", 12345.6789);
  vars.put("doubleVar2", 9876.54321);
  ProcessInstance processInstance2 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  vars = new HashMap<String, Object>();
  vars.put("doubleVar", 55555.5555);
  ProcessInstance processInstance3 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  // Query on single double variable, should result in 2 matches
  ProcessInstanceQuery query = runtimeService.createProcessInstanceQuery().variableValueEquals("doubleVar", 12345.6789);
  List<ProcessInstance> processInstances = query.list();
  assertNotNull(processInstances);
  assertEquals(2, processInstances.size());

  // Query on two double variables, should result in single value
  query = runtimeService.createProcessInstanceQuery().variableValueEquals("doubleVar", 12345.6789).variableValueEquals("doubleVar2", 9876.54321);
  ProcessInstance resultInstance = query.singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance2.getId(), resultInstance.getId());

  // Query with unexisting variable value
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals("doubleVar", 9999.99).singleResult();
  assertNull(resultInstance);

  // Test NOT_EQUALS
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueNotEquals("doubleVar", 12345.6789).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  // Test GREATER_THAN
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThan("doubleVar", 44444.4444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("doubleVar", 55555.5555).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("doubleVar", 1.234).count());

  // Test GREATER_THAN_OR_EQUAL
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("doubleVar", 44444.4444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("doubleVar", 55555.5555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("doubleVar", 1.234).count());

  // Test LESS_THAN
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThan("doubleVar", 55555.5555).list();
  assertEquals(2, processInstances.size());

  List<String> expectedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  List<String> ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expectedIds);
  assertTrue(ids.isEmpty());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThan("doubleVar", 12345.6789).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueLessThan("doubleVar", 66666.6666).count());

  // Test LESS_THAN_OR_EQUAL
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("doubleVar", 55555.5555).list();
  assertEquals(3, processInstances.size());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("doubleVar", 12344.6789).count());

  // Test value-only matching
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(55555.5555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  processInstances = runtimeService.createProcessInstanceQuery().variableValueEquals(12345.6789).list();
  assertEquals(2, processInstances.size());
  expectedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expectedIds);
  assertTrue(ids.isEmpty());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(999.999).singleResult();
  assertNull(resultInstance);

  runtimeService.deleteProcessInstance(processInstance1.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance2.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance3.getId(), "test");
}
 
Example 8
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 4 votes vote down vote up
@Deployment(resources = { "org/activiti/engine/test/api/oneTaskProcess.bpmn20.xml" })
public void testQueryIntegerVariable() {
  Map<String, Object> vars = new HashMap<String, Object>();
  vars.put("integerVar", 12345);
  ProcessInstance processInstance1 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  vars = new HashMap<String, Object>();
  vars.put("integerVar", 12345);
  vars.put("integerVar2", 67890);
  ProcessInstance processInstance2 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  vars = new HashMap<String, Object>();
  vars.put("integerVar", 55555);
  ProcessInstance processInstance3 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  // Query on single integer variable, should result in 2 matches
  ProcessInstanceQuery query = runtimeService.createProcessInstanceQuery().variableValueEquals("integerVar", 12345);
  List<ProcessInstance> processInstances = query.list();
  assertNotNull(processInstances);
  assertEquals(2, processInstances.size());

  // Query on two integer variables, should result in single value
  query = runtimeService.createProcessInstanceQuery().variableValueEquals("integerVar", 12345).variableValueEquals("integerVar2", 67890);
  ProcessInstance resultInstance = query.singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance2.getId(), resultInstance.getId());

  // Query with unexisting variable value
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals("integerVar", 9999).singleResult();
  assertNull(resultInstance);

  // Test NOT_EQUALS
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueNotEquals("integerVar", 12345).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  // Test GREATER_THAN
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThan("integerVar", 44444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("integerVar", 55555).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("integerVar", 1).count());

  // Test GREATER_THAN_OR_EQUAL
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("integerVar", 44444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("integerVar", 55555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("integerVar", 1).count());

  // Test LESS_THAN
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThan("integerVar", 55555).list();
  assertEquals(2, processInstances.size());

  List<String> expectedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  List<String> ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expectedIds);
  assertTrue(ids.isEmpty());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThan("integerVar", 12345).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueLessThan("integerVar", 66666).count());

  // Test LESS_THAN_OR_EQUAL
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("integerVar", 55555).list();
  assertEquals(3, processInstances.size());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("integerVar", 12344).count());

  // Test value-only matching
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(55555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  processInstances = runtimeService.createProcessInstanceQuery().variableValueEquals(12345).list();
  assertEquals(2, processInstances.size());
  expectedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expectedIds);
  assertTrue(ids.isEmpty());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(9999).singleResult();
  assertNull(resultInstance);

  runtimeService.deleteProcessInstance(processInstance1.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance2.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance3.getId(), "test");
}
 
Example 9
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 4 votes vote down vote up
@Deployment(resources = { "org/activiti/engine/test/api/oneTaskProcess.bpmn20.xml" })
public void testQueryShortVariable() {
  Map<String, Object> vars = new HashMap<String, Object>();
  short shortVar = 1234;
  vars.put("shortVar", shortVar);
  ProcessInstance processInstance1 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  short shortVar2 = 6789;
  vars = new HashMap<String, Object>();
  vars.put("shortVar", shortVar);
  vars.put("shortVar2", shortVar2);
  ProcessInstance processInstance2 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  vars = new HashMap<String, Object>();
  vars.put("shortVar", (short) 5555);
  ProcessInstance processInstance3 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);

  // Query on single short variable, should result in 2 matches
  ProcessInstanceQuery query = runtimeService.createProcessInstanceQuery().variableValueEquals("shortVar", shortVar);
  List<ProcessInstance> processInstances = query.list();
  assertNotNull(processInstances);
  assertEquals(2, processInstances.size());

  // Query on two short variables, should result in single value
  query = runtimeService.createProcessInstanceQuery().variableValueEquals("shortVar", shortVar).variableValueEquals("shortVar2", shortVar2);
  ProcessInstance resultInstance = query.singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance2.getId(), resultInstance.getId());

  // Query with unexisting variable value
  short unexistingValue = (short) 9999;
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals("shortVar", unexistingValue).singleResult();
  assertNull(resultInstance);

  // Test NOT_EQUALS
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueNotEquals("shortVar", (short) 1234).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  // Test GREATER_THAN
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThan("shortVar", (short) 4444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("shortVar", (short) 5555).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("shortVar", (short) 1).count());

  // Test GREATER_THAN_OR_EQUAL
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("shortVar", (short) 4444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("shortVar", (short) 5555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("shortVar", (short) 1).count());

  // Test LESS_THAN
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThan("shortVar", (short) 5555).list();
  assertEquals(2, processInstances.size());

  List<String> expectedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  List<String> ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expectedIds);
  assertTrue(ids.isEmpty());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThan("shortVar", (short) 1234).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueLessThan("shortVar", (short) 6666).count());

  // Test LESS_THAN_OR_EQUAL
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("shortVar", (short) 5555).list();
  assertEquals(3, processInstances.size());

  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("shortVar", (short) 1233).count());

  // Test value-only matching
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals((short) 5555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());

  processInstances = runtimeService.createProcessInstanceQuery().variableValueEquals((short) 1234).list();
  assertEquals(2, processInstances.size());
  expectedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expectedIds);
  assertTrue(ids.isEmpty());

  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals((short) 999).singleResult();
  assertNull(resultInstance);

  runtimeService.deleteProcessInstance(processInstance1.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance2.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance3.getId(), "test");
}
 
Example 10
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 4 votes vote down vote up
@Deployment(resources={
  "org/activiti5/engine/test/api/oneTaskProcess.bpmn20.xml"})
public void testQueryLongVariable() {
  Map<String, Object> vars = new HashMap<String, Object>();
  vars.put("longVar", 12345L);
  ProcessInstance processInstance1 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  vars = new HashMap<String, Object>();
  vars.put("longVar", 12345L);
  vars.put("longVar2", 67890L);
  ProcessInstance processInstance2 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  vars = new HashMap<String, Object>();
  vars.put("longVar", 55555L);
  ProcessInstance processInstance3 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  // Query on single long variable, should result in 2 matches
  ProcessInstanceQuery query = runtimeService.createProcessInstanceQuery().variableValueEquals("longVar", 12345L);
  List<ProcessInstance> processInstances = query.list();
  assertNotNull(processInstances);
  assertEquals(2, processInstances.size());

  // Query on two long variables, should result in single match
  query = runtimeService.createProcessInstanceQuery().variableValueEquals("longVar", 12345L).variableValueEquals("longVar2", 67890L);
  ProcessInstance resultInstance = query.singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance2.getId(), resultInstance.getId());
  
  // Query with unexisting variable value
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals("longVar", 999L).singleResult();
  assertNull(resultInstance);
  
  // Test NOT_EQUALS
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueNotEquals("longVar", 12345L).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  // Test GREATER_THAN
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThan("longVar", 44444L).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("longVar", 55555L).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("longVar",1L).count());
  
  // Test GREATER_THAN_OR_EQUAL
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("longVar", 44444L).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("longVar", 55555L).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("longVar",1L).count());
  
  // Test LESS_THAN
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThan("longVar", 55555L).list();
  assertEquals(2, processInstances.size());
  
  List<String> expecedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  List<String> ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expecedIds);
  assertTrue(ids.isEmpty());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThan("longVar", 12345L).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueLessThan("longVar",66666L).count());

  // Test LESS_THAN_OR_EQUAL
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("longVar", 55555L).list();
  assertEquals(3, processInstances.size());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("longVar", 12344L).count());
  
  // Test value-only matching
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(55555L).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  processInstances = runtimeService.createProcessInstanceQuery().variableValueEquals(12345L).list();
  assertEquals(2, processInstances.size());
  expecedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expecedIds);
  assertTrue(ids.isEmpty());
  
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(999L).singleResult();
  assertNull(resultInstance);
  
  runtimeService.deleteProcessInstance(processInstance1.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance2.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance3.getId(), "test");
}
 
Example 11
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 4 votes vote down vote up
@Deployment(resources={
  "org/activiti5/engine/test/api/oneTaskProcess.bpmn20.xml"})
public void testQueryDoubleVariable() {
  Map<String, Object> vars = new HashMap<String, Object>();
  vars.put("doubleVar", 12345.6789);
  ProcessInstance processInstance1 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  vars = new HashMap<String, Object>();
  vars.put("doubleVar", 12345.6789);
  vars.put("doubleVar2", 9876.54321);
  ProcessInstance processInstance2 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  vars = new HashMap<String, Object>();
  vars.put("doubleVar", 55555.5555);
  ProcessInstance processInstance3 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  // Query on single double variable, should result in 2 matches
  ProcessInstanceQuery query = runtimeService.createProcessInstanceQuery().variableValueEquals("doubleVar", 12345.6789);
  List<ProcessInstance> processInstances = query.list();
  assertNotNull(processInstances);
  assertEquals(2, processInstances.size());

  // Query on two double variables, should result in single value
  query = runtimeService.createProcessInstanceQuery().variableValueEquals("doubleVar", 12345.6789).variableValueEquals("doubleVar2", 9876.54321);
  ProcessInstance resultInstance = query.singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance2.getId(), resultInstance.getId());
  
  // Query with unexisting variable value
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals("doubleVar", 9999.99).singleResult();
  assertNull(resultInstance);
  
  // Test NOT_EQUALS
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueNotEquals("doubleVar", 12345.6789).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  // Test GREATER_THAN
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThan("doubleVar", 44444.4444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("doubleVar", 55555.5555).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("doubleVar",1.234).count());
  
  // Test GREATER_THAN_OR_EQUAL
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("doubleVar", 44444.4444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("doubleVar", 55555.5555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("doubleVar",1.234).count());
  
  // Test LESS_THAN
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThan("doubleVar", 55555.5555).list();
  assertEquals(2, processInstances.size());
  
  List<String> expecedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  List<String> ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expecedIds);
  assertTrue(ids.isEmpty());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThan("doubleVar", 12345.6789).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueLessThan("doubleVar",66666.6666).count());

  // Test LESS_THAN_OR_EQUAL
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("doubleVar", 55555.5555).list();
  assertEquals(3, processInstances.size());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("doubleVar", 12344.6789).count());
  
  // Test value-only matching
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(55555.5555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  processInstances = runtimeService.createProcessInstanceQuery().variableValueEquals(12345.6789).list();
  assertEquals(2, processInstances.size());
  expecedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expecedIds);
  assertTrue(ids.isEmpty());
  
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(999.999).singleResult();
  assertNull(resultInstance);
  
  runtimeService.deleteProcessInstance(processInstance1.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance2.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance3.getId(), "test");
}
 
Example 12
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 4 votes vote down vote up
@Deployment(resources={
  "org/activiti5/engine/test/api/oneTaskProcess.bpmn20.xml"})
public void testQueryIntegerVariable() {
  Map<String, Object> vars = new HashMap<String, Object>();
  vars.put("integerVar", 12345);
  ProcessInstance processInstance1 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  vars = new HashMap<String, Object>();
  vars.put("integerVar", 12345);
  vars.put("integerVar2", 67890);
  ProcessInstance processInstance2 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  vars = new HashMap<String, Object>();
  vars.put("integerVar", 55555);
  ProcessInstance processInstance3 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  // Query on single integer variable, should result in 2 matches
  ProcessInstanceQuery query = runtimeService.createProcessInstanceQuery().variableValueEquals("integerVar", 12345);
  List<ProcessInstance> processInstances = query.list();
  assertNotNull(processInstances);
  assertEquals(2, processInstances.size());

  // Query on two integer variables, should result in single value
  query = runtimeService.createProcessInstanceQuery().variableValueEquals("integerVar", 12345).variableValueEquals("integerVar2", 67890);
  ProcessInstance resultInstance = query.singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance2.getId(), resultInstance.getId());
  
  // Query with unexisting variable value
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals("integerVar", 9999).singleResult();
  assertNull(resultInstance);
  
  // Test NOT_EQUALS
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueNotEquals("integerVar", 12345).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  // Test GREATER_THAN
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThan("integerVar", 44444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("integerVar", 55555).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("integerVar",1).count());
  
  // Test GREATER_THAN_OR_EQUAL
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("integerVar", 44444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("integerVar", 55555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("integerVar",1).count());
  
  // Test LESS_THAN
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThan("integerVar", 55555).list();
  assertEquals(2, processInstances.size());
  
  List<String> expecedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  List<String> ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expecedIds);
  assertTrue(ids.isEmpty());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThan("integerVar", 12345).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueLessThan("integerVar",66666).count());

  // Test LESS_THAN_OR_EQUAL
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("integerVar", 55555).list();
  assertEquals(3, processInstances.size());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("integerVar", 12344).count());
  
  // Test value-only matching
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(55555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  processInstances = runtimeService.createProcessInstanceQuery().variableValueEquals(12345).list();
  assertEquals(2, processInstances.size());
  expecedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expecedIds);
  assertTrue(ids.isEmpty());
  
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals(9999).singleResult();
  assertNull(resultInstance);
  
  runtimeService.deleteProcessInstance(processInstance1.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance2.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance3.getId(), "test");
}
 
Example 13
Source File: ProcessInstanceQueryTest.java    From activiti6-boot2 with Apache License 2.0 4 votes vote down vote up
@Deployment(resources={
  "org/activiti5/engine/test/api/oneTaskProcess.bpmn20.xml"})
public void testQueryShortVariable() {
  Map<String, Object> vars = new HashMap<String, Object>();
  short shortVar = 1234;
  vars.put("shortVar", shortVar);
  ProcessInstance processInstance1 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  short shortVar2 = 6789;
  vars = new HashMap<String, Object>();
  vars.put("shortVar", shortVar);
  vars.put("shortVar2", shortVar2);
  ProcessInstance processInstance2 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  vars = new HashMap<String, Object>();
  vars.put("shortVar", (short)5555);
  ProcessInstance processInstance3 = runtimeService.startProcessInstanceByKey("oneTaskProcess", vars);
  
  // Query on single short variable, should result in 2 matches
  ProcessInstanceQuery query = runtimeService.createProcessInstanceQuery().variableValueEquals("shortVar", shortVar);
  List<ProcessInstance> processInstances = query.list();
  assertNotNull(processInstances);
  assertEquals(2, processInstances.size());

  // Query on two short variables, should result in single value
  query = runtimeService.createProcessInstanceQuery().variableValueEquals("shortVar", shortVar).variableValueEquals("shortVar2", shortVar2);
  ProcessInstance resultInstance = query.singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance2.getId(), resultInstance.getId());
  
  // Query with unexisting variable value
  short unexistingValue = (short)9999;
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals("shortVar", unexistingValue).singleResult();
  assertNull(resultInstance);
  
  // Test NOT_EQUALS
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueNotEquals("shortVar", (short)1234).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  // Test GREATER_THAN
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThan("shortVar", (short)4444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("shortVar", (short)5555).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThan("shortVar",(short)1).count());
  
  // Test GREATER_THAN_OR_EQUAL
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("shortVar", (short)4444).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("shortVar", (short)5555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueGreaterThanOrEqual("shortVar",(short)1).count());
  
  // Test LESS_THAN
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThan("shortVar", (short)5555).list();
  assertEquals(2, processInstances.size());
  
  List<String> expecedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  List<String> ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expecedIds);
  assertTrue(ids.isEmpty());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThan("shortVar", (short)1234).count());
  assertEquals(3, runtimeService.createProcessInstanceQuery().variableValueLessThan("shortVar",(short)6666).count());

  // Test LESS_THAN_OR_EQUAL
  processInstances = runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("shortVar", (short)5555).list();
  assertEquals(3, processInstances.size());
  
  assertEquals(0, runtimeService.createProcessInstanceQuery().variableValueLessThanOrEqual("shortVar", (short)1233).count());
  
  // Test value-only matching
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals((short) 5555).singleResult();
  assertNotNull(resultInstance);
  assertEquals(processInstance3.getId(), resultInstance.getId());
  
  processInstances = runtimeService.createProcessInstanceQuery().variableValueEquals((short)1234).list();
  assertEquals(2, processInstances.size());
  expecedIds = Arrays.asList(processInstance1.getId(), processInstance2.getId());
  ids = new ArrayList<String>(Arrays.asList(processInstances.get(0).getId(), processInstances.get(1).getId()));
  ids.removeAll(expecedIds);
  assertTrue(ids.isEmpty());
  
  resultInstance = runtimeService.createProcessInstanceQuery().variableValueEquals((short) 999).singleResult();
  assertNull(resultInstance);
  
  runtimeService.deleteProcessInstance(processInstance1.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance2.getId(), "test");
  runtimeService.deleteProcessInstance(processInstance3.getId(), "test");
}