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 
By at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Disabling the flight in D365FO (CHD - Tier 1)

 INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED)  VALUES ('<FlightObjectName>_KillSwitch', 1)  or  INSERT INTO dbo.SYSFLIGHT...