select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl businessAdministrator where t.archived = 0 and businessAdministrator.id = :userId and businessAdministrator in elements ( t.peopleAssignments.businessAdministrators ) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl excludedOwners where t.archived = 0 and excludedOwners.id = :userId and excludedOwners in elements ( t.peopleAssignments.excludedOwners ) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.archived = 0 and potentialOwners.id = :userId and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.archived = 0 and potentialOwners.id = :userId and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.status in (:status) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.status in (:status) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t , OrganizationalEntityImpl potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t , OrganizationalEntityImpl potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.status in (:status) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t , OrganizationalEntityImpl potentialOwners where t.archived = 0 and t.taskData.actualOwner = null and potentialOwners.id = :groupId and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') order by t.id DESC

select t.id, potentialOwners.id from TaskImpl t, OrganizationalEntityImpl potentialOwners where potentialOwners.id in (:groupIds) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.archived = 0 and t.taskData.actualOwner = null and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended')

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.expirationTime = :expirationDate and t.taskData.status in (:status) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and (t.taskData.expirationTime = :expirationDate or t.taskData.expirationTime is null) and t.taskData.status in (:status) order by t.id DESC

select t.id, potentialOwners.id from TaskImpl t, OrganizationalEntityImpl potentialOwners where potentialOwners.id in (:groupIds) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.archived = 0 and t.taskData.actualOwner = null and t.taskData.expirationTime = :expirationDate and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended')

select t.id, potentialOwners from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.id in (:taskIds) and potentialOwners in elements ( t.peopleAssignments.potentialOwners )

select t.id, potentialOwners.id from TaskImpl t, OrganizationalEntityImpl potentialOwners where potentialOwners.id in (:groupIds) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.archived = 0 and t.taskData.actualOwner = null and (t.taskData.expirationTime = :expirationDate or t.taskData.expirationTime is null) and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended')

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.archived = 0 and t.taskData.parentId = :parentId and (potentialOwners.id = :userId or potentialOwners.id in (:groupIds)) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.archived = 0 and t.taskData.parentId = :parentId and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl recipients where t.archived = 0 and recipients.id = :userId and recipients in elements ( t.peopleAssignments.recipients ) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl taskInitiator where t.archived = 0 and taskInitiator.id = :userId and taskInitiator = t.peopleAssignments.taskInitiator order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl taskStakeholder where t.archived = 0 and taskStakeholder.id = :userId and taskStakeholder in elements ( t.peopleAssignments.taskStakeholders ) order by t.id DESC

select new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t left join t.peopleAssignments.potentialOwners potOwners where t.archived = 0 and (t.taskData.actualOwner.id = :userId or potOwners.id = :userId) and t.taskData.status in (:status) and t.taskData.expirationTime = :expirationDate order by t.id DESC

select new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t left join t.peopleAssignments.potentialOwners potOwners where t.archived = 0 and (t.taskData.actualOwner.id = :userId or potOwners.id = :userId) and t.taskData.status in (:status) and (t.taskData.expirationTime = :expirationDate or t.taskData.expirationTime is null) order by t.id DESC

select new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t where t.archived = 0 and t.taskData.status = :status and t.taskData.activationTime < :since order by t.id DESC

select t.id, potentialOwners.id from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.id in (:taskIds) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.archived = 0 and t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended')

select new org.jbpm.services.task.query.DeadlineSummaryImpl( t.id, d.id, d.date) from TaskImpl t, DeadlineImpl d where t.archived = 0 and d in elements( t.deadlines.endDeadlines ) and d.escalated = 0 order by d.date

select new org.jbpm.services.task.query.DeadlineSummaryImpl( t.id, d.id, d.date) from TaskImpl t, DeadlineImpl d where t.archived = 0 and d in elements( t.deadlines.startDeadlines ) and d.escalated = 0 order by d.date

select new org.jbpm.services.task.query.DeadlineSummaryImpl( t.id, d.id, d.date) from TaskImpl t, DeadlineImpl d where t.id = :taskId and t.archived = 0 and d in elements( t.deadlines.endDeadlines ) and d.escalated = 0 order by d.date

select t from TaskImpl t where t.archived = 0 and t.taskData.workItemId = :workItemId

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t where t.archived = 0 and t.taskData.processInstanceId = :processInstanceId and t.name = :taskName and t.taskData.status in (:status) order by t.id DESC

select t.id from TaskImpl t where t.archived = 0 and t.taskData.processInstanceId = :processInstanceId

select a from TaskImpl t join t.taskData.attachments as a where t.id = :taskId

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.status in (:status) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t , OrganizationalEntityImpl potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and (t.taskData.expirationTime = :expirationDate or t.taskData.expirationTime is null) and t.taskData.status in (:status) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t , OrganizationalEntityImpl potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.expirationTime = :expirationDate and t.taskData.status in (:status) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.status in (:status) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and (t.taskData.expirationTime = :expirationDate or t.taskData.expirationTime is null) and t.taskData.status in (:status) order by t.id DESC

select distinct new org.jbpm.services.task.query.TaskSummaryImpl( t.id, t.name, t.description, t.taskData.status, t.priority, t.taskData.actualOwner.id, t.taskData.createdBy.id, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processInstanceId, t.taskData.parentId, t.taskData.deploymentId ) from TaskImpl t, OrganizationalEntityImpl potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and t.taskData.expirationTime = :expirationDate and t.taskData.status in (:status) order by t.id DESC