How to get Visible property of Table field?

Can any one help mw whats wrong with this code?

I want to get list of fields in a infolog which have Visible property as ‘No’.

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)
{
visibleProp = vendFlds.AOTgetProperty(‘Visible’);
if(!vendFlds.AOTgetProperty(‘Visible’))
info(strfmt(“field %1”, vendFlds.treeNodeName()));
vendFlds = vendFldsIterator.next();
}

}

Hi Swapna,

You are close. Try this -

while(vendFlds)
{

if (vendFlds.AOTgetProperty(#PropertyVisible) == ‘No’)
info(strfmt(“field %1”, vendFlds.treeNodeName()));

}

Full code below -


static void Test_Iterator(Args _args)
{
TreeNode vendFldsRoot = treeNode::findNode(@“Data DictionaryTablesVendTransFields”);
TreeNodeIterator vendFldsIterator;
TreeNode vendFlds;

#Properties
;

vendFldsIterator = vendFldsRoot.AOTiterator();
vendFlds = vendFldsIterator.next();

while(vendFlds)
{
if (vendFlds.AOTgetProperty(#PropertyVisible) == ‘No’)
{
info(strfmt(“field %1 **, Visible Property %2”, vendFlds.treeNodeName(), vendFlds.AOTgetProperty(#PropertyVisible)));
}
vendFlds = vendFldsIterator.next();
}
}

That was silly mistake. Thank you :slight_smile: