I want to get all task instances from table JBPM_TASKINSTANCES irrespective of active id's.
I have already used
but they all depend on Active Ids. I want to get all assigned and unassigned task (not complete task) instances.
You can do it with manual HQL query
select TaskInstance from org.jbpm.taskmgmt.exe.TaskInstance as TaskInstance