Cognizant Technology Solutions
Last activity: 5 Sep 2018 2:18 EDT
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:
- 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?
- 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?