Question

3
Replies
153
Views
SA_Arora Member since 2013 12 posts
Cognizant Technology Solutions
Posted: 2 years ago
Last activity: 2 years 1 month ago
Closed

Default BIX Criteria - What column of the Work table does system use?

We are using BIX rules in our application and the filter criteria we use is "Use last updated time as start". However, we see a problem at times where some of the cases/work objects are skipped and not extracted to the database tables (Output format is 'Database Schema'). Couple of questions related to this:

  1. In such a scenario, what column of the work table does Pega use to figure out the cases/work objects that need to be extracted? Is it 'pxUpdateDateTime' or 'pxSaveDateTime' or 'pxCommitDateTime' OR a combination of these 3 columns OR some other column?
  2. What could be the potential reasons for the cases/work objects being skipped during BIX extraction. I thought it might be the work object lock, however that doesn't seem to be the case. I did a POC by opening a Work object to keep it locked, ran the extract and it did go through fine to the database tables. Any other reasons that you can suggest/know about?
Low-Code App Development Data Integration
Moderation Team has archived post
Share this page LinkedIn