DateRangeTermFilter does not work when a different date format is used

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, Master
• Fix Version/s: 7.0.0 DXP FP70, 7.0.X, 7.1.X, Master
• Component/s: Search Infrastructure > Framework
• Labels:
  • 7.1-should
  • backend_test
  • ee-ts
  • liferay-dxp-70-sp10
  • liferay-fixpack-de-70-7010
  • marketplace-portal-search-elasticsearch6-1.0.1-7010
  • marketplace-portal-search-solr-1.1.1-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/59990

7.0.x - Important Change Notes
7.0.x backport of LPS-78857, LPS-79348, LPS-80931 together requires new version of Liferay Connector to Elasticsearch 6 (1.0.1+) and Liferay Solr 5 Search Engine (1.1.1+) apps to be installed.

See also https://help.liferay.com/hc/en-us/articles/360022577331.

The DateRangeTermFilter provides API to specify the date format of the lowerBound and upperBound dates. But, it does not actually work.

Steps to Reproduce

1. Navigate to the Control Panel → Server Administration
2. Navigate to Script
   • Select Groovy as the Script Type
3. Copy script from attached groovy script: DateRangeTermFilter.groovy
4. Replace code in the script console with the copied code
5. Click Execute

Expected Results:
The executed groovy script returns search results for both date formats

Actual Results:
The executed groovy script only returns search results for the default date format

Sample Output - Actual Results

/***** Running Script: DateRangeTermFilter *****/

/*** DateRangeTermFilter: using Default Date Format - yyyyMMddHHmmss ***/
Article Found: {ddmTemplateKey=[BASIC-WEB-CONTENT], entryClassPK=[36786], groupId=[20126], publishDate=[20180515183900]...}

/*** DateRangeTermFilter: using Non-Default Date Format - MMddyyyyHHmmss ***/
No Articles Found

---

Additional Details - Groovy Script
The script does the following:

1. Create a unique Web Content with an expiration date
2. Perform a search for the created WebContent using a DateRangeTermFilter with the default date format
   • Date Format: yyyyMMddHHmmss
   • Assert whether the created Web Content was returned and log result
3. Perform a search for the created WebContent using a DateRangeTermFilter with a non-default date format
   • Date Format: MMddyyyyHHmmss
   • Assert whether the created Web Content was returned and log result