Archive of posts tagged table inheritance

Table inheritance roots

Posted by on

I’m preparing a talk about table inheritance in AX 2012 and I wanted to know how many hierarchies exist in standard AX. Therefore I looked for all tables with SupportsInheritance = Yes and Extends = “”. It’s more than I expected (collected in AX 2012 R3): AgreementHeader AgreementHeaderExt_RU AgreementHeaderHistory AgreementHeaderHistoryExt_RU AgreementLine AgreementLineHistory AifDocumentFilter AifEndpointActionValueMap AifPort …

Continue reading ‘Table inheritance roots’ »

Queries to tables with inheritance

Posted by on

Table inheritance is an interesting feature of Dynamics AX 2012 allowing to model type hierarchies in database in a way similar to object modeling. Dynamics AX allows not only to define inheritance in metadata, but it also takes it automatically into account in queries to database, in forms and so on. The problem is that …

Continue reading ‘Queries to tables with inheritance’ »