Smart projects

Every Ax developer tries to group their code from one defect or one analysis in one project. Sometimes you try to maintain the AOT structure in that project through groups (don’t forget to set the property projectGroupType). What some developers don’t know is that project-groups have a property GroupMask. Here you can fill in a […]

System tables – part1

In this post I will talk about some Ax kernel tables that are automatically created after the setup at the first run of Ax. They are typically company independent (no DataAreaId) and contain some valuable information about AX. You can find the tables I wil discuss under the AOT –> System Documentation –> Tables. AccessRightsList […]

List of mandatory fields on a table

When you want a list of all the mandatory field on table X, yould check all the properties on the table fields, or you could be lazy and write a small job that does the trick for you. Just replace TableId with your tablenum. 1 2 3 4 5 6 7 8 9 10 11 […]

Moving DB-objects to other layers … without losing data

Most of us have already been confronted with the problem of tables being inserted in the wrong layer, and when they already contain data it is very difficult to transfer these objects to the correct layer without losing data. I found the following article on Axaptapedia that helps you with this issue: http://www.axaptapedia.com/Move_DB_objects_to_another_layer

Changing AOT properties from code

When you want to it is possible to change AOT properties from code. The first you need to do, is finding the treenode you want to modify: 1 2 3 4 5 #AOT #Properties TreeNode node = TreeNode::findNode(#TablesPath); ; node = node.AOTfindChild("SysUserInfo");#AOT #Properties TreeNode node = TreeNode::findNode(#TablesPath); ; node = node.AOTfindChild("SysUserInfo"); When you want to […]