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);
    }
}



Support Faryal's Cusine


DEPLOY SSRS REPORTS USING POWER SHELL – DYNAMICS 365 FOR OPERATIONS


DEPLOY SSRS REPORTS USING POWER SHELL


Open Windows PowerShell in administrator mode.
For Local environment
C:\AOSService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1
For Azure environment
J:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -PackageInstallLocation "J:\AosService\PackagesLocalDirectory"

Support Faryal's Cusine


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...