OOTB filter does not work for pxDeadlineTime
Assignments in a system are extracted using a DB-View query via report definition. pxDeadlineTime is one of the columns in the report. The report definition is used to display worklist and workbasket assignments the user portal. All the columns can be filtered using the OOTB repeat grid filter except the pxDeadlineTime column.
When attempting to filter the pxDeadlineTime column, the operation fails and an exception can bee seen in the logs.
Exception in log:
FAIL ** Name: Property Type: DATETIME, Column Type: Date, Literal Value: "20160627T220929.000 GMT" - are not of the same type.
Steps to Reproduce
Configuration has a grid sourced from a report definition on a class that is mapped to a database view:
When they try to filter the grid on the DEADLINETIME column, an exception occurs:
An issue in the custom application code or rules:
The DEADLINETIME property was originally defined as type Text. The report definition and grid were created using that property definition. The original property was withdrawn, and the DEADLINETIME property was redefined as type DateTime. This is the correct data type for the property. However, the report definition and the grid continue to see the property as type Text
Perform the following local-change: Delete the original property and recreate it as type DateTime.