Solved

Delete service orders history older than xx years

  • 9 August 2021
  • 3 replies
  • 87 views

Userlevel 3
Badge +9

We want to delete Service Order Histroy that are older then 2 year to clean up the data with GDPR Information.

 

I have an API with a delete action on service order history, but this only delete records from c_order_line, c_order_comp, c_order_env, c_service_call and c_service_call_env.

But all demand records that are attached to that service order are not deleted.

 

Is there a simple way to delete service order history with all the demands that are attached to that order.

 

For the record, we on version 15.1 and we testing on our UAT envoirement..

 

Greetz,

Robin

icon

Best answer by robinsch 2 September 2021, 16:41

View original

3 replies

Userlevel 6
Badge +10

Hi Robin,

If you have the API to delete Service Order in history, but leave orphan demand records that means there is no proper delete functionality within Service Order History.
Probably the reason why the functionality is not there because the list of tables that are linked to Service Orders are massive.
There may be invoices, financial, logistic transactions that are linked to Service Order.
In summary there is no simple way to delete Service Order History. However it is not impossible to be done, but in order to achieve it IFS Alliance expert involvement is needed.

 

Rgds,

Joshua

Userlevel 3
Badge +9

 

Hi,

For deleting History orders there is a module “Order History Archiving”, that does what i want to achieve

Userlevel 7
Badge +21

Correct but please note that Order History Archiving only archives older than three years, not two.  As long as this is enough, great!

 

Reply