Difference between different column in data type
If we download/export pega data type, we see multiple column on timestamp namely
pxCommitDateTime
pxCreateDateTime (NULL)
pxSaveDateTime
pxUpdateDateTime (NULL)
FileCreatedDate
What is difference between them ?
why createdatetime & updatedatetime are mostly NULL ?
Tata Consultancy Services
IN
Hi @ProsunG
Is your data type Database : CustomerData and these mentioned Colums Hiden in the RD --> DataTableEditorReport
Please Unhide Colums from the Respective RD then try update or create a recoord, then export the data.
Usually these values will come automatically for the database type: PegaDATA.
Thanks,
Ashok
Wipro Limited
IN
@Bhumireddy No , DataBase is PegaDATA . I would like to know the different of the above 4 columns. concrete class
Thanks
Prosun
Tata Consultancy Services
IN
Hi @ProsunG
pxCommitDateTime : Indicates the time that an update to the instance is committed to the database. Useful for system-diagnostic purposes. More accurate in many cases than pxUpdateDateTime.
pxCreateDateTime : Date and time that the object was first saved to the database. Not present or null for objects not yet saved. Read-only.
pxSaveDateTime: Date and time that an instance was saved with business changes to the database. Recommended for use in applications. More accurate in many cases than pxUpdateDateTime.
pxUpdateDateTime : Date and time of the most recent update to the work item. For more accurate results, it is recommended that you instead use either pxCommitDateTime or pxSaveDateTime.
Please go through below Standard property rules for the Diffrent OOTB Classes and Properties
I hope this will help you
Thanks,
Ashok
HCA Healthcare
US
@ProsunG In Pega, when you export or download a data type, you see several timestamp columns that serve different purposes. pxCommitDateTime records the exact time when a transaction is committed to the database. pxCreateDateTime typically stores the time when the record was first created but is often NULL in data types as it depends on explicit implementation or settings. pxSaveDateTime tracks when the record was last saved, reflecting updates or modifications. pxUpdateDateTime usually captures the last update timestamp but is often NULL if not explicitly configured in the case type or data type. FileCreatedDate refers to when the export file itself was generated and is unrelated to the record's lifecycle in Pega. The frequent NULL values in pxCreateDateTime and pxUpdateDateTime are due to their being optional fields not automatically populated unless the data model or processes explicitly define them.