Question
BIX Filter Criteria Dynamic value population
Is there a way to dynamically pass a value during BIX extract rule run time. Looking for something like, to have parameter pxCreateDateTime, the value has to less than a week of BIX rule last executed updatedatetime from PR_EXTRACT_TIME table.
Saw a similar case below in PDN
With 7.1.9, you now have the ability to specify "Last Extraction Time” to compare with any date time property to do use custom date time properties for incremental extraction. Please refer to page 11 of the BIX user guide - https://pdn.pega.com/documents/bix-71-user-guide
Excerpt below:
For a DateTime property, you can specify the symbolic value Last Extraction time. At runtime, this value is replaced with the date and time when the extract rule last ran. You can define a filter using this value as an alternative to checking the Use Last Updated Time as Start option described above, to perform incremental extraction based on any DateTime property you choose.
We currently don't have support for this in BIX. We will take this as an enhancement and let the product management know about this.