Result of the custom query jbpmHumanTaskWithUser is not properly sorted when using Oracle

Solution Unverified - Updated -

Issue

  • Calling the custom query jbpmHumanTaskWithUser returns unordered response when using Oracle database;
  • The following endpoint: /server/queries/definitions/{queryName}/data does not return properly sorted result for the following settings:

    queryName *  jbpmHumanTasksWithUser
    mapper *     UserTasksWithPotOwners
    orderBy      taskid
    page         0
    pageSize     10
    

Environment

  • Red Hat Process Automation Manager (RHPAM) 7.12, 7.13;
  • Oracle database;

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content