Support Article

Data type difference with OOTB CPMFS-Work & App Work table



Data type difference with Out-of-the-box (OOTB) CPMFS-Work & Application work table causes issue with filter with Pega Collections 7.22.

Error Messages

Union not applied because property:pxCreateDateTime in class[PegaCPMFS-Work,MGL-CAF-ESP-Work] tables are of different types[DATE,TIMESTAMP]

Steps to Reproduce

Run a report definition on the custom interaction class XXXX-Work-Interaction.

Root Cause

Table column "pxCreateDateTime" data type of OOTB CPMFS-Work table and Application work table is different.


Refer to the below PDN article and alter the field data type:

Published June 19, 2017 - Updated August 1, 2017

0% found this useful

Have a question? Get answers now.

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