Question

9
Replies
3397
Views
Sonakshi Sonakshi (SONAKSHI)
Infosys
Consultant
Infosys
NZ
SONAKSHI Member since 2011 1 post
Infosys
Posted: May 26, 2016
Last activity: October 4, 2018
Posted: 26 May 2016 17:19 EDT
Last activity: 4 Oct 2018 13:54 EDT
Closed
Solved

How to get incremental data in BIX Extract without pxCommitDateTime?

I have requirement of generating daily report using BIX extract, from a Pega internal table. The table doesn't contain pxCommitDateTime column and we don't want to add it to the table. This system is already in production and is on Pega 7.1.9. I need a way to capture daily incremental data in the BIX report.

If I tick the checkbox Use last updated time as start under Filter Criteria of the Extract rule, then it throws the error "Could not process : pxCommitDateTime column does not exist in table"

How can we get this functionality without adding pxCommitDateTime column?

I see in Pega 7 help that we can use Last Extraction time in filter condition. Can you let me know how exactly to use it? The syntax for same.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Reporting
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.