Page 1 of 1
OrderHistory Table and Update Tracking
Posted: Thu May 18, 2023 2:35 pm
by ljenkins
The SelectDB.pf.OrderHistory.Description table.field only has information when Requirements and Exceptions are deleted from a Commitment. The Description has only '<Version \>' in it when a Requirement or an Exception is added or updated.
Is it possible to update a setting in SoftPro so that the OrderHistory table shows when a Requirement or an Exception is added or updated?
Is there another way to know when a Requirement or Exception is added or updated other than the OrderHistory table?
Thanks!
Re: OrderHistory Table and Update Tracking
Posted: Mon May 22, 2023 9:52 am
by ljenkins
If it helps, we are using Version 4.3.60210.119 of SoftPro Select. If you need more table information to answer my question, please let me know.
Thanks!
Re: OrderHistory Table and Update Tracking
Posted: Thu May 25, 2023 2:46 pm
by ljenkins
Here is a screenshot of the Commitment - Schedules B1, B2 screen in SPS. The Requirements and Exceptions we are interested in tracking are on this screen. When a Requirement or an Exception is deleted and the Order saved, the Order History popup window provides information on it. See screenshots for examples.
Re: OrderHistory Table and Update Tracking
Posted: Wed May 31, 2023 4:18 pm
by BobRichards
Sadly there is no easy way to detect changes to these items. The best bet is to create a server package that can detect changes to this area. You have two options:
- IOrderStore.OrderSaved - You are passed both the saved order and the version immediately before. You can compare any order properties of interest to look for additions/changes/deletions.
- IOrderStore.OrderSaving - The same as the OrderSaved event but you also have the ability to set a flag and provide a reason to the user if your logic decides the order should not be saved because it breaks some business logic requirement.
Re: OrderHistory Table and Update Tracking
Posted: Thu Jun 08, 2023 4:26 pm
by ljenkins
Thank you, Bob!
Much appreciated,
Louise