目的

Remove Object's History logs is not possible through Assets UI. This is how to perform this action using Database queries.

This has been recorded as an improvement area for Assets:

JSDSERVER-8706 - 課題情報を取得中... ステータス

Until the product improvement is in place this Article intends to describe a way of removing Object's History records.

環境

Assets management

ソリューション

はじめる前に

Table AO_8542F1_IFJ_OBJ_HIST is where all the History values are stored for existing Objects. To verify all of the affected entries, and the database structure for further tweaks, run a select query against the object that you're looking to remove history from:

SELECT * FROM "AO_8542F1_IFJ_OBJ_HIST" 
WHERE "OBJECT_ID" = XXX;

To remove the history logs, we have 2 options, one to remove by date older than, or by specifying an object ID:

DELETE FROM "AO_8542F1_IFJ_OBJ_HIST" 
WHERE "CREATED" < '2020-12-31 00:00:00.0';

または

DELETE FROM "AO_8542F1_IFJ_OBJ_HIST" 
WHERE "OBJECT_ID" = XXX;