Solved

Delete service orders history older than xx years

3 years ago
August 9, 2021
3 replies
101 views

+10

robinsch
Hero (Customer)
58 replies

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

Best answer by robinsch

Hi,

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

View original

Did this topic help you find an answer to your question?

J

+12

Joshua Liem
Superhero (Employee)
112 replies
3 years ago
August 10, 2021

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

A