Question
bitsinglass
IN
Last activity: 28 Apr 2025 7:49 EDT
How to generate BIX Report should include cases which had status changes in last 24 hours only
Hi
We have case which goes through multiple case statuses, we would like to generate bix report which will include the cases which have changed the status in last 24 hours
is it possible in BIX?
do we need to use history table for this?
what should be filter criteria?
Updated: 28 Apr 2025 3:26 EDT
Pegasystems Inc.
IN
bitsinglass
IN
@BoggapxCommitDateTime can be updated when ever other operations on the case are performed other than status change also I need all the history of case status changes
Tata Consultancy Services
IN
You can added the these fields into your bix rule
pyStatusWorkTimestamp --> DateTime when work status was last updated, Used by activity Work-.StatusElapsedCalculation which is called by a trigger whenever pyStatusWork changes
pyStatusWork
pyStatusWorkOld --> Property to store the old value of the Work status, Used by trigger Work-.StatusElapsedCalculation to know what the work status value was before it changed
I hope this will help you
Thanks,
Ashok
@VivekK16711353
Whenever case status changes, OOTB properties like pxUpdateDateTime or pxCommitDateTime also changes. So, in the BIX extract rule in filters you can use pxCommitDateTime is greater thanlast extraction time.
The job scheduler which runs extract rule can be configured to run once every 24 hours.