A Filter on a DATETIME Column is Not Visible When the Analysis is Edited in Oracle Analytics (Doc ID 2857316.1)

Last updated on MARCH 29, 2022

Applies to:

Symptoms

A new analysis is created in Answers with various presentation columns selected, and filters are created on the columns.

If a filter is created on a Presentation Column which is mapped to a Physical Column of type DATETIME, then that filter does not display / render in the Criteria tab of the analysis. For example, the following may be observed in the Filters pane:

Filters
   Person ID is equal to / is in 12345
  AND Contract Type is equal to / is in CT-123
  OR

When the issue is encountered, see the following error is observed in the web browser's Developer Tools > Console page:

Uncaught TypeError: Cannot read properties of null (reading 'getUTCOffsetByMinutes')
at SAWDateTime.getResultOffset (datetime.js:1:5078)
at SAWDateTime.getDataToDisplayOffsetFromInfo (datetime.js:1:5796)
at SAWDateTime.convertDataToDisplayTZFromInfo (datetime.js:1:6057)
at Function.FilterEditor.adjustDataToDisplayTZOffsetForDT (filtereditor.js:1:42400)
at Function.FilterEditor.getHtmlForDateTimeLiteral (filtereditor.js:1:21472)
at Function.FilterEditor.getHtmlForExpr (filtereditor.js:1:16740)
at Function.FilterEditor.getHtmlForDisplayValue (filtereditor.js:1:22481)
at Function.FilterEditor.getCellForList (filtereditor.js:1:29722)
at Function.FilterEditor.getCellForComparison (filtereditor.js:1:25503)
at Function.FilterEditor.addCellsForExpr (filtereditor.js:1:15384)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.