ievgensaxblog: Advanced cross-reference search.

[Blog bot]

Источник: https://ievgensaxblog.wordpress.com/...erence-search/
==============



Cross-reference is one of the best tools we have in AX that is used by developers daily, however, not everyone is using it for 100%.

Recently, I was asked how to find cross-references for a kernel method that is not defined on a table, because you cannot right click on it   And that’s a good question, often we want to find if there is a call to doUpdate or doInsert somewhere.

In AX 2012 go to Tools -> Cross-reference -> Names and filter by table or method name and then click Used by.





Using this form, we can find usage of CRL types as well, for example, Microsoft.Dynamics.IntegrationFramework.  It is defined in AOT under references node, however, from there you cannot find any references.  Names would show you everything!



What about D365FOE?

As we know, it’s a bit different here. Cross-references data is moved to DYNAMICSXREFDB database.



And it makes perfect sense because you need to pay for each GB of DB space in Production.

Using next SQL statement, we can find usage of any object. For example, Microsoft.Dynamics.IntegrationFramework :

SELECT sourceName.[Path] as sourcePath, targetName.[Path] as targetPath, [Kind], [Line], [Column], sourceModule.[Module] as sourceModule, targetModule.[Module] as targetModule FROM dbo.[References] INNER JOIN dbo.[Names] sourceName ON dbo.[References].[SourceId] = sourceName.[Id] INNER JOIN dbo.[Modules] sourceModule ON sourceName.[ModuleId] = sourceModule.[Id] INNER JOIN dbo.[Names] targetName ON dbo.[References].[TargetId] = targetName.[Id] INNER JOIN dbo.[Modules] targetModule ON targetName.[ModuleId] = targetModule.[Id] WHERE targetName.[Path] like '%Microsoft.Dynamics.IntegrationFramework%'

Where Kind is:

/// /// Types of Cross References /// public enum CrossReferenceKind { /// /// Type not specified. Used for queries /// Any = 0, /// /// Indicates that the reference is a Method Call /// MethodCall = 1, /// /// Type reference /// Indicated that the type is used (variable and field declaration, attributes, function return type, etc) /// TypeReference = 2, /// /// Interface implementation /// Indicates that the source entity is implementing this interface /// InterfaceImplementation = 3, /// /// Class Extended /// Indicates that the source entity is extending this class or interface /// ClassExtended = 4, /// /// Test Call /// Indicates that the source entity (test) directly or indirectly calls an application method. /// TestCall = 5, /// /// Property /// Indicates that the source entity has a certain property. /// Property = 6, /// /// Attribute reference /// Indicated that an Attribute is used /// Attribute = 7, /// /// Test Helper Call /// Indicates that the source entity is a test helper. /// TestHelperCall = 8, /// /// Metadata or code Tag reference /// Indicates that the source tag is used on a metadata element, class or a method or a line of code. /// Tag = 9, } Let’s try doUpdate:



As we can see, result is different to AX 2012, where we could search for an individual table, now all Common methods have reference to Common.






Источник: https://ievgensaxblog.wordpress.com/...erence-search/