web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :

X++ job to get tablenames which has cachelookup property set to EntireTable

Chaitanya Golla Profile Picture Chaitanya Golla 17,225
static void TableProperty(Args _args)
{
    #AOT
    Treenode    tableNode;
    Treenode    table;
    Form        actualTable;
    str         TableGroup;
    str         tableName;
    str         tblProperty;
    int         nodeCount;
    ;
    
    tableNode = treenode::findNode(#TablesPath);

    nodeCount = tableNode.AOTchildNodeCount();
    table = tableNode.AOTfirstChild();

    while (table)
    {
        tableName = table.AOTgetProperty("Name");
        actualTable = tableNode.AOTfindChild(tableName);

        tblProperty = actualTable.AOTgetProperty('CacheLookup');

        if (tblProperty == 'EntireTable')
            info(strFmt("TableName: %1 - CacheLookup: %2", tableName, tblProperty));

        table = table.AOTnextSibling();
    }
}

Comments

*This post is locked for comments