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.