How can we extract data from using bix for a table which doesnt have a pxcreatedatetime and pxupdatedatetime
We have a requirement to extract the history table data but that table doesn't have pxcreatedatetime and pxupdatedatetime. That table has a property pxTimeCreated. Can we extract this table thru bix with pxtimecreated ? else could you please suggest how to extract this table , on what bases ?
***Updated by moderator: Lochan to add Categories***
Pegasystems Inc.
IN
Updated: 4 Apr 2018 3:50 EDT
TCS
IN
how can we do that , the pr_extract_time table doesn't contain that column itself. And bix will be using this table to access the db and extract the data. could you elaborate if you have anything on this.
Updated: 4 Apr 2018 5:24 EDT
Pegasystems Inc.
IN
Hi,
As you mentioned that "That table has a property pxTimeCreated" , I assumed that the pr_extract_time table has this property.
At my side I can see pr_extract_time table contains below properties.
If pylastupdate and pxcreatedatetime property are not present then I don't believe you can extract based on any filter. What all properties you can see in your table?
Thank You
TCS
IN
We were not able to do that with pxTimeCreated as I don't have this column in pr_extract_time. We have pxupdatetime, pxCreateDateTime and pzinskey columns in that table.
Pegasystems Inc.
US
I believe history tables can also be extracted using bix normally.
Which version of bix are you on?
TCS
IN
We are using Pega 7.1.6 Bix
Pegasystems Inc.
IN
Hi ,
Please have a look at below article
so for the history classes if you use pxTimeCreated it should .
Please run the extract once and let us know the result.
Thanks,
Arun
Hi,
I guess you can use the property (pxTimeCreated) in filter field and extract the data.
Thank You