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)

Dynamically setting entire Form security access through Extension in D365FO

/// <summary> /// To check if user can get access to the Parameter form /// </summary> class SAN_ParamFormsAccessCtrl {     prot...