Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

OOTB filter does not work for pxDeadlineTime

SA-42573

Summary



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.

Error Messages



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:




Root Cause



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


Resolution



Perform the following local-change: Delete the original property and recreate it as type DateTime.

Suggest Edit

Published August 26, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us