When spending a lot of your working day in the AOT you end up with a lot of ideas to tools that could make your development tasks easier, help you do things faster or just automate repetitive tasks.
In this blog post I will show you how to quickly make the foundation for a new add-in. The example will create a record counter that simply returns a record count in the info log when activated from a table node in the AOT.
To do so we need 4 things:
- The class that does the actual work
- A menu item that triggers the class
- A reference to this menu item in the context menu
- Few lines of code in a standard class to make sure the menu item only shows when positioned on a table
Let us start up with the class. In this example I have a class that looks like this:
private void run(Args _args)
// Check that we are executing from a context menu
// Get the tree node of the context menu
treeNode = _args.parmObject().first();
// Check that we have a hit and that we are on a table element
if (treeNode && treeNode.utilElement().recordType == UtilElementType::Table)
// Present the record count to the user
info(strFmt("@SYS97212", new SysDictTable(tableName2id(treeNode.treeNodeName())).recordCount()));
public static void main(Args _args)
That is a very simple example; but to show the concept it should do.
Next step is to create a menu item. There is no fancy stuff here. Just a plain menu item.
In the AOT find the SysContextMenu under the Menus node. This is the menu shown when you right click in the AOT and select Add-ins. Drag your new menu item to the menu to the position in the menu you prefer.
We are almost there. All we need now is to make sure that the menu item only is shown when you right click on a table. To do so find the class SysContextMenu and the method called verifyItem.
What this method does is to look at the menu item and menu item type given as parameters and return a 0 or 1 equals hide or show. The method is structured fairly simple with switches to locate the switch on menu item type matching your above created menu item and in the nested switch add the following case :
// Check that we are not on an old node and only one node is selected
if (this.selectionCount() != 1 || firstNode.AOTIsOld())
// Check that we are on a table node
if (!docNode && _firstType==UtilElementType::Table)
And now your done. Test it by right clicking on a table in the AOT, select Add-ins and your new menu item.