Order by web content structure field doesn't work in Asset Publisher

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: 7.2.10 DXP FP12, 7.2.X, 7.3.10 DXP FP2, 7.3.X, 7.4.13 DXP GA1, Master
• Component/s: Content Display Widgets > Asset Publisher widget, Data Engine
• Labels:
  • QA-AUTOMATION
  • ee-ts
  • liferay-fixpack-dxp-12-7210
  • liferay-fixpack-dxp-2-7310
  • migration_to_dataengine
• Branch Version/s:
  7.3.x, 7.2.x
• Backported to Branch:
  Committed
• Fix Priority: 4
• Sprint: Data_Engine_7.4_06
• Git Pull Request: https://github.com/liferay-data-engine/liferay-portal/pull/82
• QA Test Name:
  • LocalFile.AssetPublisherUseCase#AssetPublisherFilterAndOrderByFieldType
• QA Test Score: 5

Step to reproduce:

1. Add a web content structure with a Numeric field
2. Add the first web content based on new structure
3. Type Web Content Title 1 as title and Type 5 in Numeric field
4. Add the second web content based on new structure
5. Type Web Content Title 2 as title and Type 3 in Numeric field
6. Add the third web content based on new structure
7. Type Web Content Title 3 as title and Type 8 in Numeric field
8. Add a widget page
9. Add an Asset Pubilsher to page
10. Assert the order of web contents is Web Content Title 3, Web Content Title 2, Web Content Title 1
11. Click the ellipsis button on the topper of Asset Publisher > Configuration
12. Expand Source section
13. Select Web Content Article in Asset Type
14. Select new structure in Web Content Article Structures
15. Expand Ordering section
16. Select the Numeric field in Order by
17. Assert order arrow is ascending
18. Save
19. Close modal

Expected Results:
The order of web contents is Web Content Title 2, Web Content Title 1, Web Content Title 3

Actual Results:
The order of web contents is Web Content Title 1, Web Content Title 2, Web Content Title 3

Reproduced on:
Tomcat 9.0.37 + MySQL 5.7. Portal master GIT ID: b265d851edce5207d5da8198f1f01d96554e8499.