Posted: 16 Jan 2020 1:33 EST Last activity: 31 Jan 2020 21:13 EST
Filter criteria for BIX extract from pr_operators table
We have a requirement to extract pr_operators table to external database using BIX extract. The current criteria to extract the records is to check if pxupdatedatetime of operator record is greater than pxextractdatetime.
Issue: We are using a model operator to create operators in LDAP, which is saving all the operator records with same pxupdatedatetime of the model operator. The BIX extract job ran fine for the first time, however from the second run, above mentioned criteria was never matching and none of the new records are extracted.
Please suggest a solution here, so that any newly added or updated record in pr_operators table is properly extracted. We have tried to use existing properties like PXCOMMITDATETIME, PXSAVEDATETIME but none of them are returning right set of results.
The ask here is to only extract the delta between last and current run of BIX.
Thank you for posting your query. Is the model operator having the same update/creation time for all the operators?
I believe BIX is referring to a pxUpdateDateTime property which is the same for all the operators in your case. Correct me if I'm wrong. Please share the screenshots of your configuration for model operator.