Bug 1082699 - Add ability to paginate queries
Summary: Add ability to paginate queries
Keywords:
Status: CLOSED EOL
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: jBPM Core
Version: 6.0.1
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ER3
: 6.1.0
Assignee: Shelly McGowan
QA Contact: Ivo Bek
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-03-31 16:20 UTC by Ivo Bek
Modified: 2020-03-27 19:43 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2020-03-27 19:43:32 UTC
Type: Feature Request
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker JBPM-4151 0 Minor Closed Adding pagination parameters (max results, etc) to jbpm-audit queries, operations and commands 2015-08-27 11:04:27 UTC

Description Ivo Bek 2014-03-31 16:20:42 UTC
Description of problem:

Java API and Java Remote API don't have full ability to paginate queries. For example I am not able to say how many process instances I want to get when I request all of them via kieSession.getProcessInstances() or auditService.findProcessInstances().

I know this might be complicated to change interfaces TaskService, KieSession, and AuditLogService but it is not efficient to get all the tasks/process instances at once. Maybe for KieSession it is not necessary to add pagination since all the information are already in memory.

In TaskService I found only one method where it is possible to paginate results:

List<TaskSummary> getTasksAssignedAsPotentialOwner(String userId, List<String> groupIds, String language, int firstResult, int maxResults);

And auditing lack this functionality according to the connected JIRA JBPM-4151.

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 Kris Verlaenen 2014-03-31 18:19:00 UTC
Please note that ksession.getProcessInstances() will only return the active processes "in the session", when using persistence process instances are stored in the db and released, so in that case this operation will return an empty list.  I don't think it's therefore necessary to add pagination operations for that method.  For task and audit log etc. they do make sense, we will consider adding them to the (internal) interfaces (at least), and/or as params to the remote operations.

Comment 2 JBoss JIRA Server 2014-09-30 01:05:11 UTC
Marco Rietveld <marco.rietveld> updated the status of jira JBPM-4151 to Closed

Comment 3 Marco Rietveld 2014-11-28 10:33:52 UTC
This has been done as part of the new rich query functionality. 

Please see the ../rest/query/runtime/process functionality. 

TEMPORARY documentation can be found here: 
https://github.com/mrietveld/droolsjbpm-integration/wiki/jBPM-Rest-Query-API

Comment 4 Ivo Bek 2015-02-09 12:13:54 UTC
Verification blocked by BZ 1174885

Comment 5 Ivo Bek 2015-02-23 11:36:41 UTC
Verified in BPMS 6.1.0.ER5


Note You need to log in before you can comment on or make changes to this bug.