PUBLIC - Liferay Portal Community Edition
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-18291

Kaleo Web Plugin - My Workflow Tasks Advanced Search by Type does not return results when using PostgreSQL, Oracle, Sybase, and DB2

    Details

    • Type: Bug Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 6.0.6 GA, 6.0.12 EE, 6.1.0 CE RC1, 6.1.1 CE GA2, 6.1.20 EE GA2
    • Labels:
      None
    • Environment:
    • Branch Version/s:
      6.1.x, 6.0.x
    • Backported to Branch:
      Committed
    • Epic/Theme:
    • Fix Priority:
      4
    • Similar Issues:
      Show 4 results 

      Description

      Using an advanced search by Type doesn't return results

      Steps to reproduce:
      1. Deploy the kaleo web plugin
      2. Navigate to the 'Control Panel' and click 'Workflow Configuration' on the left-hand column
      3. For the Resource Web Content, select 'Single Approver (Version 1)' workflow
      4. Click 'Save'
      5. Click 'Web Content' on the left-hand column
      6. Click 'Add'
      7. Fill in a title and content, and click 'Submit for Publication'
      8. Click 'My Workflow Tasks' on the left-hand column. The web content created in Step 4 should display under 'Assigned to My Roles' (AdvancedSearch1.JPG)
      9. Click on 'Advanced>>' to open up the Advanced Search interface
      10. Select 'Any' next to Match
      11. Select 'Web Content' under Type
      12. Click 'Search'. The Web Content created in Step 4 will not display in the results (AdvancedSearch2.JPG)

      **Issue does not occur in MySQL 5 or SQL Server 2008.

      **Unable to test in DB2 in 6.1.x Revision 83917.

        Issue Links

          Activity

          Hide
          Brian Chiu added a comment -

          No Longer Reproducible on:
          Tomcat 7.0.27 + DB2. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a.
          Tomcat 7.0.27 + Oracle 10. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a.
          Tomcat 7.0.27 + Oracle 11. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a.
          Tomcat 7.0.27 + PostgreSQL 8.4. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a.
          Tomcat 7.0.27 + PostgreSQL 9.0. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a.
          Tomcat 7.0.27 + SQL Server 2005. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a.
          Tomcat 7.0.27 + SQL Server 2008. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a.
          Tomcat 7.0.27 + Sybase 15. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a.
          Plugins 6.1.x EE GIT ID: c3dba9f1016a969b7408838bdf87e40e0ff85730.

          Tomcat 6.0.33 + SQL Server 2008. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811.
          Plugins 6.0.x EE GIT ID: 92224f9229ee3f0716e28366e9cbefb284f80795.

          Reproduced on:
          Tomcat 6.0.33 + DB2. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811.
          Tomcat 6.0.33 + Oracle 10. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811.
          Tomcat 6.0.33 + Oracle 11. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811.
          Tomcat 6.0.33 + PostgreSQL 8.4. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811.
          Tomcat 6.0.33 + PostgreSQL 9.0. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811.
          Tomcat 6.0.33 + SQL Server 2005. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811.
          Tomcat 6.0.33 + Sybase. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811.
          Plugins 6.0.x EE GIT ID: 92224f9229ee3f0716e28366e9cbefb284f80795.

          Show
          Brian Chiu added a comment - No Longer Reproducible on: Tomcat 7.0.27 + DB2. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a. Tomcat 7.0.27 + Oracle 10. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a. Tomcat 7.0.27 + Oracle 11. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a. Tomcat 7.0.27 + PostgreSQL 8.4. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a. Tomcat 7.0.27 + PostgreSQL 9.0. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a. Tomcat 7.0.27 + SQL Server 2005. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a. Tomcat 7.0.27 + SQL Server 2008. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a. Tomcat 7.0.27 + Sybase 15. Portal 6.1.x EE GIT ID: 6c9aac244d5214b7b6526b7aa8d3c89a33a22d6a. Plugins 6.1.x EE GIT ID: c3dba9f1016a969b7408838bdf87e40e0ff85730. Tomcat 6.0.33 + SQL Server 2008. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811. Plugins 6.0.x EE GIT ID: 92224f9229ee3f0716e28366e9cbefb284f80795. Reproduced on: Tomcat 6.0.33 + DB2. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811. Tomcat 6.0.33 + Oracle 10. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811. Tomcat 6.0.33 + Oracle 11. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811. Tomcat 6.0.33 + PostgreSQL 8.4. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811. Tomcat 6.0.33 + PostgreSQL 9.0. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811. Tomcat 6.0.33 + SQL Server 2005. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811. Tomcat 6.0.33 + Sybase. Portal 6.0.x EE GIT ID: b4de1abfebdb48253fa754a5ab5221337625c811. Plugins 6.0.x EE GIT ID: 92224f9229ee3f0716e28366e9cbefb284f80795.
          Hide
          Oriana Tham (Inactive) added a comment -

          No Longer Reproducible on:

          Tomcat 7.0.27 + DB2. Portal 6.1.x EE GIT ID: 6d280617f28523c41bd9dae101c9b948eb6abaf0.
          Tomcat 7.0.27 + PostgreSQL 9.0. Portal 6.1.x EE GIT ID: 6d280617f28523c41bd9dae101c9b948eb6abaf0.

          Show
          Oriana Tham (Inactive) added a comment - No Longer Reproducible on: Tomcat 7.0.27 + DB2. Portal 6.1.x EE GIT ID: 6d280617f28523c41bd9dae101c9b948eb6abaf0. Tomcat 7.0.27 + PostgreSQL 9.0. Portal 6.1.x EE GIT ID: 6d280617f28523c41bd9dae101c9b948eb6abaf0.
          Hide
          Justin Choi added a comment - - edited

          PASSED Manual Testing following the steps in the description.

          Fixed on:
          Tomcat 7.0 + DB2. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee.
          Tomcat 7.0 + Postgre 8.4. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee.
          Tomcat 7.0 + Postgre 9.0. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee.
          Tomcat 7.0 + Sybase 15.0.2. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee.
          Tomcat 7.0 + Oracle 10.2. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee.
          Tomcat 7.0 + Oracle 11.2. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee.

          • When searching for web content articles in the My Workflow Task search field, the system will return the correct query if set to the "Any" field.
          Show
          Justin Choi added a comment - - edited PASSED Manual Testing following the steps in the description. Fixed on: Tomcat 7.0 + DB2. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee. Tomcat 7.0 + Postgre 8.4. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee. Tomcat 7.0 + Postgre 9.0. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee. Tomcat 7.0 + Sybase 15.0.2. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee. Tomcat 7.0 + Oracle 10.2. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee. Tomcat 7.0 + Oracle 11.2. Portal 6.2.x CE GIT ID: dfb9e6c6141688cb1095782b4f34468c0c31e846. Plugins 6.2.x CE GIT ID: 714c43fcb2f3adb9302fcca3076d288d19c231ee. When searching for web content articles in the My Workflow Task search field, the system will return the correct query if set to the "Any" field.
          Hide
          Justin Choi added a comment -

          Currently Blocked by LPS-31769

          Show
          Justin Choi added a comment - Currently Blocked by LPS-31769
          Hide
          Justin Choi added a comment -

          Reproduced on:
          Tomcat 6.0.33 + DB2. Portal 6.0.x EE GIT ID: 9d3b01f7410c04cf6aa53a5295c252e6c7d3ea3f. Plugins 6.0.x EE GIT ID: f763075750e46a7d5eb1ae32e2454e791635364f.
          Tomcat 6.0.33 + Oracle 10. Portal 6.0.x EE GIT ID: 9d3b01f7410c04cf6aa53a5295c252e6c7d3ea3f. Plugins 6.0.x EE GIT ID: f763075750e46a7d5eb1ae32e2454e791635364f.
          Tomcat 6.0.33 + Oracle 11. Portal 6.0.x EE GIT ID: 9d3b01f7410c04cf6aa53a5295c252e6c7d3ea3f. Plugins 6.0.x EE GIT ID: f763075750e46a7d5eb1ae32e2454e791635364f.
          Tomcat 6.0.33 + PostgreSQL 8.4. Portal 6.0.x EE GIT ID: 9d3b01f7410c04cf6aa53a5295c252e6c7d3ea3f. Plugins 6.0.x EE GIT ID: f763075750e46a7d5eb1ae32e2454e791635364f.
          Tomcat 6.0.33 + PostgreSQL 9.0. Portal 6.0.x EE GIT ID: 9d3b01f7410c04cf6aa53a5295c252e6c7d3ea3f. Plugins 6.0.x EE GIT ID: f763075750e46a7d5eb1ae32e2454e791635364f.

          • Per Igor Beslic, the user cannot search using the web content title. The user must search using the task name (e.g. Review). This is working as intended.
          • When I set the Match criteria to "Any", searching for Article 1 with Web Content Type selected should return Article 1 because "Any" means either/or. This works in 6.2.x but not in 6.0.x. The issue is probably with the search portlet, not Kaleo-web.
          Show
          Justin Choi added a comment - Reproduced on: Tomcat 6.0.33 + DB2. Portal 6.0.x EE GIT ID: 9d3b01f7410c04cf6aa53a5295c252e6c7d3ea3f. Plugins 6.0.x EE GIT ID: f763075750e46a7d5eb1ae32e2454e791635364f. Tomcat 6.0.33 + Oracle 10. Portal 6.0.x EE GIT ID: 9d3b01f7410c04cf6aa53a5295c252e6c7d3ea3f. Plugins 6.0.x EE GIT ID: f763075750e46a7d5eb1ae32e2454e791635364f. Tomcat 6.0.33 + Oracle 11. Portal 6.0.x EE GIT ID: 9d3b01f7410c04cf6aa53a5295c252e6c7d3ea3f. Plugins 6.0.x EE GIT ID: f763075750e46a7d5eb1ae32e2454e791635364f. Tomcat 6.0.33 + PostgreSQL 8.4. Portal 6.0.x EE GIT ID: 9d3b01f7410c04cf6aa53a5295c252e6c7d3ea3f. Plugins 6.0.x EE GIT ID: f763075750e46a7d5eb1ae32e2454e791635364f. Tomcat 6.0.33 + PostgreSQL 9.0. Portal 6.0.x EE GIT ID: 9d3b01f7410c04cf6aa53a5295c252e6c7d3ea3f. Plugins 6.0.x EE GIT ID: f763075750e46a7d5eb1ae32e2454e791635364f. Per Igor Beslic, the user cannot search using the web content title. The user must search using the task name (e.g. Review). This is working as intended. When I set the Match criteria to "Any", searching for Article 1 with Web Content Type selected should return Article 1 because "Any" means either/or. This works in 6.2.x but not in 6.0.x. The issue is probably with the search portlet, not Kaleo-web.
          Hide
          Justin Choi added a comment - - edited

          Per conversation with Igor Beslic - the search result works but there are two new issues:

          igor.beslic:
          it is bug in 6.0.x and I think not the same we fixed for 6.2.x and backported to 6.1.x and 6.0.x
          good idea to link this two, since now user will at least know what he is searching
          hey, I left comment to LPS-27211 and left reference to LPS-31737

          Show
          Justin Choi added a comment - - edited Per conversation with Igor Beslic - the search result works but there are two new issues: igor.beslic: it is bug in 6.0.x and I think not the same we fixed for 6.2.x and backported to 6.1.x and 6.0.x good idea to link this two, since now user will at least know what he is searching hey, I left comment to LPS-27211 and left reference to LPS-31737

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 3 days ago

                Development

                  Structure Helper Panel