Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Completed workflow tasks ordering is not consistent between MySQL 5 and PostgreSQL 8.

Description

Steps to reproduce:
1. Deploy kaleo-web plugin
2. Navigate to Control Panel > Workflow Configuration
3. Select Single Approver (Version 1) near Web Content
4. Add Web Content Article and Submit for Publication
5. Click My Workflow Tasks > Actions > Assign to Me > OK
6. Actions > Reject > OK
7. Actions > Resubmit > OK
8. Actions > Assign to Me > OK
9. Actions > Approve > OK
10. Click Completed Tab

You will notice in PostgreSQL the "update" task is at the bottom of the list, but in MySQL the "update" task is in the middle of the list. It should be consistent across databases. (See attachments)

Environment

Tomcat 7 + PostgreSQL 8. 6.1.x GIT ID: a56b18dd997640ae470df55dc1be8bae519a8134. Tomcat 7 + PostgreSQL 8. 6.2.x GIT ID: 3b7823d386c28d7d8eb3d07dc1acb81c975cc40b.

Attachments

2

Activity

Show:

Cynthia Wilburn March 12, 2012 at 2:00 PM

Reopening to add 6.1.1 CE GA2. Close as Fixed.

Robert Srisam-ang February 2, 2012 at 12:10 PM

PASSED Manual Testing following the steps in the description.

Fixed on:
Tomcat 7 + PostgreSQL 8. 6.1.x GIT ID: 49f750bfe0f04f0f3326e38aad59790fa4753875. 6.1.x Plugins GIT ID: e1d63755da7a58659109fbf51b03614b9fd5cd14.
Tomcat 7 + PostgreSQL 8. 6.2.x GIT ID: 7617f526037bc0bb6546b61e6a2834047ad10586. 6.2.x Plugins GIT ID: 61e6fa0903e8a1a785dc7f3dc94ffe78149ac85e.

Completed workflow tasks ordering is consistent between MySQL 5 and PostgreSQL 8.

Robert Srisam-ang February 1, 2012 at 12:33 PM

FAILED Manual Testing following the steps in the description.

Failed on:
Tomcat 7 + PostgreSQL 8. 6.1.x GIT ID: c2df229d78899f13c0c3ce3e1070cf15d969569b.
Tomcat 7 + PostgreSQL 8. 6.2.x GIT ID: 33b972d0a9e492a371f8272b38692c65d6dcdb75.

Issue is failing because of http://issues.liferay.com/browse/LPS-25259. Waiting for that issue to get fixed before re-testing.

Michael Han January 31, 2012 at 9:59 PM

This is actually due to the way the workflow portlets are passing the order by parameters to the kaleo queries

Fixed

Details

Assignee

Reporter

Labels

Branch Version/s

6.1.x

Backported to Branch

Committed

Fix Priority

2

Databases

PostgreSQL 8.4

Git Pull Request

Bug Type

Regression Bug

Components

Fix versions

Affects versions

Priority

Zendesk Support

Created January 18, 2012 at 4:01 PM
Updated June 24, 2023 at 3:47 PM
Resolved March 12, 2012 at 2:48 PM
Loading...