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 :
sourceName.[Path] as sourcePath,
targetName.[Path] as targetPath,
sourceModule.[Module] as sourceModule,
targetModule.[Module] as targetModule
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,
/// 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.