Loop through all the fields of a table in Ax 2012

Here we will find all fields from table using loop through all the fields of a table in X++:

static void FindFieldFromtable(Args _args)
{
    SysDictTable    dictTable = new SysDictTable(tableNum(A_PO));
    SysDictField    dictField;
    TreeNode        treeNode;
    FieldId         fieldId = dictTable.fieldNext(0);

    while (fieldId)
    {
        dictField = dictTable.fieldObject(fieldId);

        if (dictField.isSql() && !dictField.isSystem())
        {
            treeNode = dictField.treeNode();
            info(strFmt("%1 | %2 | %3",
                dictField.name(),                                               // Field name
                treeNode.AOTgetProperty("Label"),                               // Label id
                SysLabel::labelId2String(treeNode.AOTgetProperty("Label"))));   // Label string
        }
        fieldId = dictTable.fieldNext(fieldId);
    }
}

More info:- lookUp with all tables and related fields,
How to make lookup of all fields in a table in ax 2012? 

Run and get Fields from table.

Author : Umesh Patel

Related Posts