Query Zone Search Result Issue With Date Time DST
(Doc ID 2466197.1)
Last updated on SEPTEMBER 27, 2022
Applies to:Oracle Utilities Mobile Workforce Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 2.3]
Information in this document applies to any platform.
**Disclaimer:** This KM article may include the following abbreviations:
MWM - Oracle Utilities Mobile Workforce Management
CM - Customer Modification
DST - Daylight Saving Time
On : 126.96.36.199.0 version, System Wide
Query zone search result issue with date time DST
Example: In the Mail search zone, I created a Mail record with creation date time 09-24-2018 12:12AM PST as displayed in the screen. In the database this is saved as 09-23-2018 23:12:51
When I search for Mails From Date = 09-24-2018, this record is not retrieved. I was expecting that this record will be retrieved since I am seeing on the screen that this is created 09-24-2018.
When I search for Mails From Date = 09-23-2018, this record is being displayed.
We are encountering the same issue in our CM search zones. Since this issue is also present in the base search zone, we would like to know how this will be fixed in the base zone so we can ensure that our solution for CM will behave the same.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!