How to use

org.camunda.bpm.engine.impl.db.ListQueryParameterObject

constructor

public DbOperation deleteHistoricIncidentsByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("removalTime", removalTime);
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 parameters.put("batchSize", batchSize);
 return getDbEntityManager()
  .deletePreserveOrder(HistoricIncidentEntity.class, "deleteHistoricIncidentsByRemovalTime",
   new ListQueryParameterObject(parameters, 0, batchSize));
}

public DbOperation deleteAttachmentsByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("removalTime", removalTime);
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 parameters.put("batchSize", batchSize);
 return getDbEntityManager()
  .deletePreserveOrder(AttachmentEntity.class, "deleteAttachmentsByRemovalTime",
   new ListQueryParameterObject(parameters, 0, batchSize));
}

public DbOperation deleteExternalTaskLogByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("removalTime", removalTime);
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 parameters.put("batchSize", batchSize);
 return getDbEntityManager()
  .deletePreserveOrder(HistoricExternalTaskLogEntity.class, "deleteExternalTaskLogByRemovalTime",
   new ListQueryParameterObject(parameters, 0, batchSize));
}

public DbOperation deleteExternalTaskLogByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("removalTime", removalTime);
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 parameters.put("batchSize", batchSize);
 return getDbEntityManager()
  .deletePreserveOrder(HistoricExternalTaskLogEntity.class, "deleteExternalTaskLogByRemovalTime",
   new ListQueryParameterObject(parameters, 0, batchSize));
}

public DbOperation deleteJobLogByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("removalTime", removalTime);
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 parameters.put("batchSize", batchSize);
 return getDbEntityManager()
  .deletePreserveOrder(HistoricJobLogEventEntity.class, "deleteJobLogByRemovalTime",
   new ListQueryParameterObject(parameters, 0, batchSize));
}

public DbOperation deleteHistoricBatchesByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) {
 Map<String, Object> parameters = new HashMap<>();
 parameters.put("removalTime", removalTime);
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 parameters.put("batchSize", batchSize);
 return getDbEntityManager()
  .deletePreserveOrder(HistoricBatchEntity.class, "deleteHistoricBatchesByRemovalTime",
   new ListQueryParameterObject(parameters, 0, batchSize));
}

public DbOperation deleteHistoricDetailsByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("removalTime", removalTime);
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 parameters.put("batchSize", batchSize);
 return getDbEntityManager()
  .deletePreserveOrder(HistoricDetailEventEntity.class, "deleteHistoricDetailsByRemovalTime",
   new ListQueryParameterObject(parameters, 0, batchSize));
}

public DbOperation deleteHistoricActivityInstancesByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("removalTime", removalTime);
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 parameters.put("batchSize", batchSize);
 return getDbEntityManager()
  .deletePreserveOrder(HistoricActivityInstanceEntity.class, "deleteHistoricActivityInstancesByRemovalTime",
   new ListQueryParameterObject(parameters, 0, batchSize));
}

public DbOperation deleteHistoricIdentityLinkLogByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) {
 Map<String, Object> parameters = new HashMap<>();
 parameters.put("removalTime", removalTime);
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 parameters.put("batchSize", batchSize);
 return getDbEntityManager()
  .deletePreserveOrder(HistoricIdentityLinkLogEntity.class, "deleteHistoricIdentityLinkLogByRemovalTime",
   new ListQueryParameterObject(parameters, 0, batchSize));
}

public DbOperation deleteByteArraysByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("removalTime", removalTime);
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 parameters.put("batchSize", batchSize);
 return getDbEntityManager()
  .deletePreserveOrder(ByteArrayEntity.class, "deleteByteArraysByRemovalTime",
   new ListQueryParameterObject(parameters, 0, batchSize));
}

public DbOperation deleteHistoricBatchesByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) {
 Map<String, Object> parameters = new HashMap<>();
 parameters.put("removalTime", removalTime);
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 parameters.put("batchSize", batchSize);
 return getDbEntityManager()
  .deletePreserveOrder(HistoricBatchEntity.class, "deleteHistoricBatchesByRemovalTime",
   new ListQueryParameterObject(parameters, 0, batchSize));
}

@SuppressWarnings("unchecked")
public List<String> findHistoricProcessInstanceIdsForCleanup(Integer batchSize, int minuteFrom, int minuteTo) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("currentTimestamp", ClockUtil.getCurrentTime());
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 ListQueryParameterObject parameterObject = new ListQueryParameterObject(parameters, 0, batchSize);
 return (List<String>) getDbEntityManager().selectList("selectHistoricProcessInstanceIdsForCleanup", parameterObject);
}

@SuppressWarnings("unchecked")
public List<String> findHistoricDecisionInstanceIdsForCleanup(Integer batchSize, int minuteFrom, int minuteTo) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("currentTimestamp", ClockUtil.getCurrentTime());
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 ListQueryParameterObject parameterObject = new ListQueryParameterObject(parameters, 0, batchSize);
 return (List<String>) getDbEntityManager().selectList("selectHistoricDecisionInstanceIdsForCleanup", parameterObject);
}

@SuppressWarnings("unchecked")
public List<String> findHistoricCaseInstanceIdsForCleanup(int batchSize, int minuteFrom, int minuteTo) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("currentTimestamp", ClockUtil.getCurrentTime());
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 ListQueryParameterObject parameterObject = new ListQueryParameterObject(parameters, 0, batchSize);
 return getDbEntityManager().selectList("selectHistoricCaseInstanceIdsForCleanup", parameterObject);
}

@SuppressWarnings("unchecked")
public List<String> findHistoricProcessInstanceIdsForCleanup(Integer batchSize, int minuteFrom, int minuteTo) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("currentTimestamp", ClockUtil.getCurrentTime());
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 ListQueryParameterObject parameterObject = new ListQueryParameterObject(parameters, 0, batchSize);
 return (List<String>) getDbEntityManager().selectList("selectHistoricProcessInstanceIdsForCleanup", parameterObject);
}

@SuppressWarnings("unchecked")
public List<String> findHistoricDecisionInstanceIdsForCleanup(Integer batchSize, int minuteFrom, int minuteTo) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("currentTimestamp", ClockUtil.getCurrentTime());
 if (minuteTo - minuteFrom + 1 < 60) {
  parameters.put("minuteFrom", minuteFrom);
  parameters.put("minuteTo", minuteTo);
 }
 ListQueryParameterObject parameterObject = new ListQueryParameterObject(parameters, 0, batchSize);
 return (List<String>) getDbEntityManager().selectList("selectHistoricDecisionInstanceIdsForCleanup", parameterObject);
}

public void updateBatchSuspensionStateById(String batchId, SuspensionState suspensionState) {
 Map<String, Object> parameters = new HashMap<String, Object>();
 parameters.put("batchId", batchId);
 parameters.put("suspensionState", suspensionState.getStateCode());
 ListQueryParameterObject queryParameter = new ListQueryParameterObject();
 queryParameter.setParameter(parameters);
 getDbEntityManager().update(BatchEntity.class, "updateBatchSuspensionStateByParameters", queryParameter);
}

@SuppressWarnings("unchecked")
public List<Event> findEventsByTaskId(String taskId) {
 checkHistoryEnabled();
 ListQueryParameterObject query = new ListQueryParameterObject();
 query.setParameter(taskId);
 query.getOrderingProperties().add(new QueryOrderingProperty(new QueryPropertyImpl("TIME_"), Direction.DESCENDING));
 return getDbEntityManager().selectList("selectEventsByTaskId", query);
}

@SuppressWarnings("unchecked")
public List<Event> findEventsByTaskId(String taskId) {
 checkHistoryEnabled();
 ListQueryParameterObject query = new ListQueryParameterObject();
 query.setParameter(taskId);
 query.getOrderingProperties().add(new QueryOrderingProperty(new QueryPropertyImpl("TIME_"), Direction.DESCENDING));
 return getDbEntityManager().selectList("selectEventsByTaskId", query);
}

@Test
public void shouldUseCfgValue_always() {
 final ListQueryParameterObject query = new ListQueryParameterObject();
 final AuthorizationCheck authCheck = query.getAuthCheck();
 // given
 when(mockedConfiguration.getAuthorizationCheckRevokes()).thenReturn(ProcessEngineConfiguration.AUTHORIZATION_CHECK_REVOKE_ALWAYS);
 // if
 authorizationManager.configureQuery(query);
 // then
 assertEquals(true, authCheck.isRevokeAuthorizationCheckEnabled());
 verifyNoMoreInteractions(mockedEntityManager);
}