Data type difference with OOTB CPMFS-Work & App Work table
SummaryData type difference with Out-of-the-box (OOTB) CPMFS-Work & Application work table causes issue with filter with Pega Collections 7.22.
Union not applied because property:pxCreateDateTime in class[PegaCPMFS-Work,MGL-CAF-ESP-Work] tables are of different types[DATE,TIMESTAMP]
Steps to ReproduceRun a report definition on the custom interaction class XXXX-Work-Interaction.
Table column "pxCreateDateTime" data type of OOTB CPMFS-Work table and Application work table is different.
ResolutionRefer to the below PDN article and alter the field data type:https://pdn.pega.com/release-note/support-oracle-timestamp-data-types
Published June 19, 2017 - Updated August 1, 2017