Queries to tables with inheritance

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’ »

AX2012: Subqueries in views

Dynamics AX 2012 supports computed columns in AOT views. That allows you to convert a value of a field in some way, to actually compute a value based on several fields and so on, and it’s all defined directly in SQL Server as any other view. Indeed, the definition of a computed column just generates …

Continue reading ‘AX2012: Subqueries in views’ »