Bug 743404 - SQL Pagination with TaskServiceSession.getTasksAssignedAsPotentialOwner
Summary: SQL Pagination with TaskServiceSession.getTasksAssignedAsPotentialOwner
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Enterprise BRMS Platform 5
Classification: JBoss
Component: jBPM 5
Version: BRMS 5.3.0.GA
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Kris Verlaenen
QA Contact: Lukáš Petrovický
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-10-04 19:41 UTC by Jeffrey Bride
Modified: 2011-11-14 16:23 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-11-14 16:23:47 UTC
Type: ---

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

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
Note You need to log in before you can comment on or make changes to this bug.