Get Field, Label, Type and Name D365FO



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



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




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

    info(fieldPName(CustTable,AccountNum));
}




Following is the way to find the 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);
    }
}



2 comments:

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

    ReplyDelete
  2. How we can get list of menu items with their label

    ReplyDelete

Virtual Fields Vs Computed Fields

  Virtual Field: A virtual field in D365FO is a field that doesn't have a direct representation in the database. It's a field that y...