Bug 743404

Summary:	SQL Pagination with TaskServiceSession.getTasksAssignedAsPotentialOwner
Product:	[JBoss] JBoss Enterprise BRMS Platform 5	Reporter:	Jeffrey Bride <jbride2001>
Component:	jBPM 5	Assignee:	Kris Verlaenen <kverlaen>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Lukáš Petrovický <lpetrovi>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	BRMS 5.3.0.GA	CC:	brms-jira
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-11-14 16:23:47 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Jeffrey Bride 2011-10-04 19:41:04 UTC

in some BPM use cases, thousands of tasks could be assigned to a single groupId.  currently, the TaskServiceSession.getTasksAssignedAsPotentialOwner method returns the full result set of instantiated TaskSummary objects.

Recommend that SQL pagination be built into this query so as to limit the result set to a configurable size.

Default page size could be about 20 if none is specified by the invoking client.

Comment 1 Jeffrey Bride 2011-10-18 17:31:02 UTC

please see new overloaded 'getTasksAssignedAsPotentialOwner' method in the following :

https://github.com/jbride/jbpm/blob/gbd/jbpm-human-task/src/main/java/org/jbpm/task/service/TaskServiceSession.java