Posted: 17 Aug 2015 12:33 EDT Last activity: 2 Sep 2015 3:25 EDT
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.
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
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.