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);}
}
This is great. Do you think this can be done just by SQL and export a list?
ReplyDeleteHow we can get list of menu items with their label
ReplyDelete