As per the BIX User guide, we are planning to run our first time extract so we wanted to manipulate the pyLastUpdateTime col value so that Filter criteria "Use last updated time as start" on BIX Extract rule will take the delta for the next run. But looks like the table structure of pr_extract_time is missing col pyLastUpdateTime as given in the Page36 of https://docs.pega.com/bix-81-user-guide?check_logged_in=1. We see only PYLASTUPDATEDATE col. Do we need to update PYLASTUPDATEDATE which is of type DATE. Will Extract rule run will take timestamp also from PYLASTUPDATEDATE col? Can someone please guide us on the same?
Name Null? Type
---------------- -------- ------------------
PYINSNAME NOT NULL VARCHAR2(255 CHAR)
PXCREATEDATETIME NOT NULL DATE
If you go to class Pega-Extract-Time and open this property pyLastUpdateDate then you will notice this is a DATETIME property and if you go to the Modify Schema Landing Page and select this table then you will notice that this column is of type TIMESTAMP.
So if we go with the below statement from the guide :
"Two fields have been added to the main table for each extracted class in the database, pxExtractDateTime.TIMESTAMP and pxRunIdentifier VARCHAR(255)."
The two fields should be - pyLastUpdateDate(pxExtractDateTime) and pyInsName(pxRunIdentifier).
Posted: 1 month ago
Posted: 12 Jul 2022 11:39 EDT
Jeyachandra Pandiyan Pandiyan (Jey2705)
Thanks for your response. So if I have to manipulate my BIX Extract rule run to say run from a particular time then I can update the PYLASTUPDATEDATE along with timestamp value (HH:MM:ss) through a DML script. So that Filter criteria "Use last updated time as start" will read that PYLASTUPDATEDATE and pick only records from Work class that got updated after PYLASTUPDATEDATE? Please clarify. Thanks!