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