Question

7
Replies
842
Views
Elton Janssen (JANSE)
PEGA
Consulting Manager
Pegasystems
NL
JANSE Member since 2011 5 posts
PEGA
Posted: August 19, 2015
Last activity: August 21, 2015
Posted: 19 Aug 2015 7:40 EDT
Last activity: 21 Aug 2015 4:45 EDT
Closed
Solved

BIX updatedatetime

We have the BIX framework installed on top of our application.

As per the BIX documentation it is not possible to only extract delta's from the classes like Assign- and History-. This is because the pxUpdateDate column does not exist for these tables and BIX uses this to identify the delta records.

However we have made this working by manually adding a column to the history table called pxUpdateDateTime. The value inserted here is autogenerated by the Oracle DB (Default value) and inserts the current system time whenever a new record is added.

The question actually is....while this seems as an easy enough solution should we actually be doing this and are we not affecting the BIX functionality in some kind of negative way?

Data Integration System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.