The purpose of this blog is for knowledge sharing and connect the relevant audience who are all into Microsoft Dynamics world.
Alfasith AX

اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا
Saturday, November 17, 2018
Thursday, November 15, 2018
Job to list all the fields in particular table in D365
Hi,
class AlfasithTableFieldList
{
/// <summary>
/// Runs the class with the specified arguments.
/// </summary>
/// <param name = "_args">The specified arguments.</param>
public static void main(Args _args)
{
TableName tableName = 'SalesTable';
SysModelElement sysModelElementTables;
SysModelElement SysModelElementFields;
DictField dictField;
;
while select sysModelElementTables
where sysModelElementTables.ElementType == UtilElementType::Table &&
sysModelElementTables.Name == tableName
join SysModelElementFields
where SysModelElementFields.ElementType == UtilElementType::TableField &&
SysModelElementFields.ParentModelElement == sysModelElementTables.RecId
{
dictField = new DictField(sysModelElementTables.AxId, sysModelElementFields.AxId);
print dictField.name();
}
}
}
Regards,
class AlfasithTableFieldList
{
/// <summary>
/// Runs the class with the specified arguments.
/// </summary>
/// <param name = "_args">The specified arguments.</param>
public static void main(Args _args)
{
TableName tableName = 'SalesTable';
SysModelElement sysModelElementTables;
SysModelElement SysModelElementFields;
DictField dictField;
;
while select sysModelElementTables
where sysModelElementTables.ElementType == UtilElementType::Table &&
sysModelElementTables.Name == tableName
join SysModelElementFields
where SysModelElementFields.ElementType == UtilElementType::TableField &&
SysModelElementFields.ParentModelElement == sysModelElementTables.RecId
{
dictField = new DictField(sysModelElementTables.AxId, sysModelElementFields.AxId);
print dictField.name();
}
}
}
Regards,
Subscribe to:
Posts (Atom)
Get a table ID in SQL - D365
Hi select ID from SysTableIdView where SysTableIdView .Name = 'CustTable' Regards,
-
Hi, AccountingDistribution ( accounting distribution 7452 ) AccountingDistributionEventTmp ( accounting distribution 100001 ) Accountin...
-
//< What is GUID> // GUID 16 bit large range of alphanumeric similar to RecID to treat as primary key of a table. static void CreateG...