Support Article
Bix extract on history class using -g uses pxTimeCreated
SA-42174
Summary
When running an extract on a history class and passing “-g” and “-G” parameters, the Where clause in the query is using pxTimeCreated. However, according to BIX documentation “-g” and “-G” parameters should extract instances based on pxCommitDateTime.
Error Messages
Not applicable
Steps to Reproduce
Not applicable
Root Cause
This is expected behavior.
Resolution
For history tables, Extract rules have always looked at the pxTimeCreated value only instead of pxCreateDateTime/pxUpdateDateTime/pxCommitDateTime.
Published August 24, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.