Question
Infosys
IN
Last activity: 16 Oct 2018 12:03 EDT
pxCreateDateTime not working
Hi,
Im using pxCreateDateTime in report definition ,but its not rendering the value in the report. Please help me here.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems Inc.
US
Can you run Tracer when running the report and include the DB Query event type? In the Tracer, do you see the proper query generated? If you run the query directly in the database, do you see the expected results?
Infosys
IN
HI,
Thanks for the reply .
We invoked the Data Transform "pyDefault" explicitly while creating the instance if the class . This intern invokes "pyDfault" from @bassclass which sets pxCreateDateTime .This data reflects in the DB column and report definition for now we are going with this in our implementation.
But still the question is i could see blob containing pxCreateDateTime and not populating in the DB column.
Pegasystems Inc.
IN
Hi Sundeep,
If Blob has the value then there is now way that RD will not populate it (Unless Blob is corrupt).
As you have used Data Transform, there is good chance that instance gets created with pxCreateDateTime.
Can you please suggest the method you have used to verify the value in Blob column.
One way is to make a objOpen by handle and check the value.
Regards,
Ujjwal
Pegasystems Inc.
US
Hi,
Can you try to run ootb report definition and check if pxCreateDateTime can be rendered?
For example, open OOTB Report Definition, 'pzGetListOfApplications' under Rule-Application class. Run it, you will see the 'Create Date/Time' column is there. See attached screenshots.
If ootb report definition works ok, then please follow ootb and to create your report definition.
In terms of debugging the issue, collect the tracer log (check DB query event) when you run the report definition, it will tell you if pxCreateDateTime value is retrieved or not.
Thanks,
Susan
Infosys
IN
HI,
Thanks for the replies.
We invoked the Data Transform "pyDefault" explicitly while creating the instance if the class . This intern invokes "pyDfault" from @bassclass which sets pxCreateDateTime .This data reflects in the DB column and report definition for now we are going with this in our implementation.
But still the question is i could see blob containing pxCreateDateTime and not populating in the DB column.
Pegasystems Inc.
US
Hi,
Can you run Tracer for populating data in DB column? (include the DB query event type in the tracer setting.)
In tracer log, you can see why the data is not populated in DB column.
Thanks,
Susan
Tata Consultancy Services Ltd
AU
Hi All,
I am also facing the same issue, the data stored in the table for the pxCreateDateTime is 10/15/17 12:00 AM. But when we retrieve the data using the data page via report definition the pxCreateDateTime is 20171014T160000.000 GMT. Any suggestions for the difference in the pxcreatedatetime.
Pegasystems Inc.
IN
Time is not different, only formats are. The one you get in RD is Pega date format and the one you see in DB is local time. Looking at the difference, your DB time is GMT + 8 hours so I'd put your servers in Western Australia timezone.