Filter on report generates an error due to timestamp column
SummaryWhen the user tries to perform filter on the column which has the column type as "TimeStamp(7)" in Oracle database, it gives an error.
Error MessagesAn error occurred during resolving the report definition - Name: Property Type: DATETIME, Column Type: DATE, Literal Value: "20160826T074053.000 GMT" - are not of the same type.
Steps to Reproduce1. Create a Report definition with a column which has coulmn type in Database as "TimeStamp".
2. Run the report.
3. Perform filter on that column which has "TimeStamp" as column type in Database.
4. Observe the error on the screen.
Root CauseReport definition code supports TIMESTAMP(6) and the column data type user is using is of TIMESTAMP(7). Hence is the error.
Alter the table column type to use TIMESTAMP(6) instead of TIMESTAMP(7). Else use joins in the report definition instead of mapping a view to the class.
Published September 16, 2016 - Updated September 27, 2016