Thursday, 14 February 2013
I skipped Initialization checklist, how can I get it back and perform steps?
Path:
System administration/Area page/Setup/Checklists/Intialization checklist
System administration/Area page/Setup/Checklists/Intialization checklist
Friday, 8 February 2013
How to find out number of records in each table using code?
static void myJob(Args _args)
{
#AOT
#Properties
TreeNodeIterator iterator;
TreeNode treeNode;
iterator = Treenode::findNode(#TablesPath).AOTiterator();
//make the tree node point to the first table
treenode = iterator.next();
while (treeNode)
{
if (treeNode.AOTgetProperty(#PropertyTableGroup) == 'Main' && treeNode.AOTgetProperty(#PropertySaveDataPerCompany) == 'Yes')
{
info(strFmt("Table Name : %1 Legal Entity: %2 Total Records:%3", treenode.AOTname(), curext(),SysDictTable::casRecordCount(TreeNode.AOTname(),true)));
}
treeNode = iterator.next();
}
}
{
#AOT
#Properties
TreeNodeIterator iterator;
TreeNode treeNode;
iterator = Treenode::findNode(#TablesPath).AOTiterator();
//make the tree node point to the first table
treenode = iterator.next();
while (treeNode)
{
if (treeNode.AOTgetProperty(#PropertyTableGroup) == 'Main' && treeNode.AOTgetProperty(#PropertySaveDataPerCompany) == 'Yes')
{
info(strFmt("Table Name : %1 Legal Entity: %2 Total Records:%3", treenode.AOTname(), curext(),SysDictTable::casRecordCount(TreeNode.AOTname(),true)));
}
treeNode = iterator.next();
}
}
Subscribe to:
Posts (Atom)