Skip to main content

Posts

Showing posts with the label Data dictionary

Code to Get all table id of axapta AOT

By
Try this code in job static void findTables(Args _args) { Dictionary dictionary; TableId tableId; tableName tableName; ; dictionary = new Dictionary(); tableId = dictionary.tableNext(0); tableName = dictionary.tableName(tableId); while (tableId) { info(strfmt("%1 - %2",int2str(tableId), tableName)); tableId = dictionary.tableNext(tableId); tableName = dictionary.tableName(tableId); } }
Read more

Get a list of tables related to specific configuration keys in Dynamics Axapta

By
static void FindTablesFromConfigKey(Args _args) { // The name of the configuration key to be specified here str configKeyName = "Prod"; Dictionary dictionary = new Dictionary(); ConfigurationKeyId configKeyId = dictionary.configurationKeyName2Id(configKeyName); TableId tableId; DictConfigurationKey dictConfigurationKey; DictTable dictTable; container keyIds; int i; ; if (configKeyId) { // Find all children of the specified configuration key for (i = dictionary.configurationKeyNext(0); i; i = dictionary.configurationKeyNext(i)) { dictConfigurationKey = new DictConfigurationKey(i); while (dictConfigurationKey.parentConfigurationKeyId()) dictConfigurationKey = new DictConfigurationKey(dictConfigurationKey.parentConfigurationKeyId()); if (dictConfigurationKey.id() == configKeyId) keyIds += i...
Read more