Dynamics Community Forum Thread Details

delete_from {data entity}

I would like to confirm that I fully understand the option "Truncate entity data" in Data Management.

When this option is selected in the header of the Import group definition, it will call delete_from {Target entity} for every entity in the group definition lines.

I have found the code which does this job in the DMFEntityWriter::truncateEntityData(...) method

This function turns off delete validations and delete action restrictions:

targetData.skipDataSourceValidateDelete(true);

targetData.skipAosValidation(true);

targetData.checkRestrictedDeleteActions(false);

targetData.skipDatabaseLog(true);

targetData.selectForUpdate(true);

So in some cases it can leave some garbage data in DB and (hopefuly) rare occasions the user will not be able to import the data again?

What I would like to check is what really happens when delete_from {Data entity} is called. Does the kernel translates this to delete_from table (from the main data source) and the other tables are not touched, but delete actions (cascade delete) is working? Or is there something more?

I was trying to check the docs, but there is nothing except the example that an entity might be deleted

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/build-consuming-data-entities

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/cross-company-behavior

Another doubt, how does delete_from {Data entity} relates to tables where data is saved per company? According to Docs when table is per company and there is no primary company context to set it should delete only records from current company, however I have one example of such setup but truncate data entity option removed all records in all legal entities (EmployeeTable_RU table and HcmWorkerAdvHolderTableEntity entity)

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL