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;
}
// Find all tables that have an appropriate configuration key
i = 0;
for (tableId = dictionary.tableNext(0);tableId;tableId = dictionary.tableNext(tableId))
{
dictTable = new DictTable(tableId);
if (!dictTable.isMap() && !dictTable.isTmp() && !dictTable.isView())
{
if (confind(keyIds, dictTable.configurationKeyId()))
{
i++;
info(dictTable.name());
}
}
}
}
info(strfmt("%1 tables have configuration key '%2'", i, configKeyName));
}
Tuesday, 6 December 2011
Llist of tables related to specific configuration keys
Subscribe to:
Post Comments (Atom)
AZURE INTERVIEW QUESTIONS AND ANSWERS
AZURE INTERVIEW QUESTIONS AND ANSWERES 2021 2. What is cloud computing? Explanation: It is the use of servers on the internet to “store...
-
D365 INTERVIEW QUESTIONS Technical For Functional click here 1. What are the new features of D365 ? WHATS NEW IN D365 di...
-
D365 F&O FUNCTIONAL INTERVIEW QUESTIONS Below are the general functional interview questions asked .Please note that the interview...
-
EVENT HANDLERS IN D365 With D365 event handlers play very important and hence we need to know how and when to use them to maximum bene...
-
How to write a validate write data event handler code for a table Right-click onValidatedWrite of the event at the table level, and then...
Thanks for sharing information. Nice Blog.
ReplyDeleteD365 finance and operations
D365 finance and operations online training