Monday, August 28, 2017

SQL query to identify Modified objects

select top 10000 (select top 1  name from ModelElement where ModelElement.ElementHandle = ModelElementData.ElementHandle),
(select top 1  name from ModelElement where ModelElement.RootHandle = ModelElementData.ElementHandle),
(select top 1  name from ModelElement where ModelElement.ElementHandle =ModelElementData. ParentHandle),
(select top 1  name from ModelElement where ModelElement.RootHandle = ModelElementData.ParentHandle),
MODIFIEDDATETIME,*
 from ModelElementData where  layerid=14 order by ModelElementData.MODIFIEDDATETIME desc 

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...