SONAKSHI Member since 2011 1 post
Posted: 4 years ago
Last activity: 2 years 10 months ago

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.

Moderation Team has archived post
Share this page LinkedIn