Asset publisher filtering and ordering by non-localizable structure field will show incorrect results for non-default languages

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, 7.1.X, 7.2.X, Master
• Fix Version/s: 7.1.10 DXP FP15, 7.1.X, 7.2.10 DXP FP1, 7.2.X, 7.2.1 CE GA2, Master
• Component/s: Dynamic Data Mapping
• Labels:
  • ee-ts
  • liferay-fixpack-dxp-1-7210
  • liferay-fixpack-dxp-15-7110
• Branch Version/s:
  7.2.x, 7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/76407

Reproducing steps

Filtering

1. Create a new web content structure, call it str01, with a single field (e.g., a text field) and make it non-localizable.
2. Create (if needed) a template for the structure.
3. Create two web contents for that structure, wc01 with text hello01 and wc01 with text hello02, for the default language (en-US) and for another language (es-ES). (Notice that the untranslated field can only be filled in for the first language.)
4. In a page, add an Asset Publisher.
5. Configure the Asset Publisher as follows:
   1. In Source, select for Asset Type _ the value _Web Content Article
   2. For Web Content Article Structures select str01
   3. Enable Filter by Field
   4. Type in the value hello01 and select the radio button. Click on Apply
      Observerd: The Asset Publisher shows just the web content wc01
6. Change to the locale es-ES.
   Expected: The Asset Publisher also shows just the web content wc01
   Observed: The Asset Publisher won't show any results.

Ordering

1. Use the same web contents as before
2. Configure an Asset Publisher as follows:
   1. In Source, select for Asset Type _ the value _Web Content Article
   2. For Web Content Article Structures select str01
   3. Do not enable Filter by Field
   4. Down in ORDERING, for the dropdown Order by select the field for structure str01 and for the dropdown And Then by select Title.
      Observed: The Asset Publisher orders the contents by the field content. If we go to the Asset Publisher configuration again and choose the opposite ordering direction (click on the pair of arrows) we see changes.
3. Change to the locale es-ES.
   Expected: The Asset Publisher behaves just like for the locale en-US
   Observed: Changing the ordering direction for the first criterion (Order by) does nothing, but changing the ordering direction for the second criterion (And Then by) does.

Note: Even though the structure field is non-localizable, the created web contents are indexed with localized keys. For example: {{ "ddm_keyword38623_Text3xwl_en_US_String_sortable" : "hello01"}}.