Monday, July 2, 2018

Get Field, Label, Type and Name using X++






Following are they way to get Table Label
static void Job21(Args _args)
{
    info(TablePName(CustTable));
}




Following are they way to get Field Label of the table
static void Job21(Args _args)
{

    info(fieldPName(CustTable,AccountNum));
}



Following is the way to find Label , Name and Data type of all fields of any table.
static void Job21(Args _args)
{

    DictTable       dt=new SysDictTable(tableNum(CustTable));
    FieldId       _fieldId=  dt.fieldNext(0);
    DictField     _dictField;
    
while(_fieldId)
    {
      _dictField  =dt.fieldObject(_fieldId);
 info(strFmt("Field Name %1 , Field Lable %2 and Field Type %3", _dictField.name(),_dictField.label(),_dictField.type()));
     _fieldId=  dt.fieldNext(_fieldId);
    }
}


1 comment:

  1. This is great. Do you think this can be done just by SQL and export a list?

    ReplyDelete