How to get Table field properties through X++ Code

Here is a job of how you can do that:

 

static void Job5(Args _args)

{

    TreeNode            vendFldsRoot = treeNode::findNode(@"\Data Dictionary\Tables\VendTable\Fields");

    TreeNodeIterator    vendFldsIterator;

    TreeNode            vendFlds;

    NoYes               visibleProp;

    ;

 

    vendFldsIterator = vendFldsRoot.AOTiterator();

    vendFlds = vendFldsIterator.next();

 

    while(vendFlds)

   {

        if(vendFlds.AOTgetProperty('Visible') == 'No')

        info(strfmt("field %1", vendFlds.treeNodeName()));

        vendFlds    =   vendFldsIterator.next();

    }

 

}

 

Thanks,

Swapna.