Wednesday, April 3, 2019

Cleaning up cross-reference DB in Dynamics 365 for finance and operation ON DEV VM


// For unwanted cross reference data clean Up on DB (DYNAMICSXREFDB)

DELETE [REFERENCES] FROM [REFERENCES]
    JOIN Names 
ON (Names.Id = [REFERENCES].SourceId 
OR Names.Id = [REFERENCES].TargetId)
    JOIN Modules 
ON Names.ModuleId = Modules.Id


No comments:

Post a Comment

Convert Call stack to readable format in D365FO X++

//Input --container _xppCallStack = xSession::xppCallStack();  Public static str POL_formatXppCallStack(container _xppCallStack, int _skipFr...