How to: Update the data in D365FO table in production environment
vinitgoyal2005
6,332
Like
Share
ReportDid you ever wish that you could just update or delete some data in D365FO production with out custom script route. The way we had access to AX 2012 AOT tables. Of course it is not possible to do it in D 365 FO directly but I developed a small job which accepts some parameters to update/ delete the data in production environment directly.
THIS IS ONLY FOR SENIOR DEVELOPER who understands the D365FO table structure properly and understand the consequences of updating the data in prod. So Please use it with caution and check the result in an environment where Production copy exists.
internal final class XXXDataOprerations
{
/// <summary>
/// Class entry point. The system will call this method when a designated menu
/// is selected or when execution starts and this class is set as the startup class.
/// </summary>
/// <param name = "_args">The specified arguments.</param>
public static void main(Args _args)
{
Dialog dialog = new Dialog('Data operations');
DialogField dlgTableName, dlgFieldName,dlgUpdateFieldName, dlgUpdateValue, dlgForce, dlgOperation, dlgFilter;
TableId tableId;
FieldId fieldId,updateFieldId;
Common common;
// Add dialog fields
dlgTableName = dialog.addField(extendedTypeStr(TableName), 'AOT Table Name');
dlgFieldName = dialog.addField(extendedTypeStr(FieldName), 'AOT Field Name');
dlgUpdateFieldName = dialog.addField(extendedTypeStr(FieldName), 'AOT Field name that needs to be updated');
dlgFilter = dialog.addField(extendedTypeStr(String255), 'Value for filter criteria');
dlgUpdateValue = dialog.addField(extendedTypeStr(String255), 'New Value (only if Update)');
dlgOperation = dialog.addField(enumStr(BICDataOperations), 'Operation');
dlgForce = dialog.addField(extendedTypeStr(NoYesId), 'Force (Skip Validation)');
if (dialog.run())
{
// Convert input strings to IDs
tableId = tableName2Id(dlgTableName.value());
fieldId = fieldName2Id(tableId, dlgFieldName.value());
if (!tableId || !fieldId)
{
throw error('Invalid Table or Column Name.');
}
// Create a dynamic table buffer
DictTable dictTable = new DictTable(tableId);
common = dictTable.makeRecord();
ttsbegin;
while select forUpdate common
where common.(fieldId) == dlgFilter.value()
{
if (dlgOperation.value() == XXXDataOperations::Select)
{
info(strFmt('select record found with Recid %1',common.RecId));
}
else if (dlgOperation.value() == XXXDataOperations::Delete)
{
if (dlgForce.value())
{
common.doDelete();
info(strFmt('%1 record FORCE deleted.',common.RecId));
}
else
{
common.delete();
info(strFmt('%1 record deleted.',common.RecId));
}
}
else if (dlgOperation.value() == XXXDataOperations::Update)
{
updateFieldId = fieldName2Id(tableId, dlgUpdateFieldName.value());
if(updateFieldId)
{
common.(updateFieldId) = dlgUpdateValue.value();
if (dlgForce.value())
{
common.doUpdate();
info(strFmt('%1 record FORCE updated.',common.RecId));
}
else
{
common.update();
info(strFmt('%1 record updated.',common.RecId));
}
}
else
{
throw error('Invalid Table or Column Name.');
}
}
}
ttscommit;
info("Operation completed successfully.");
}
}
}
Create new Enum: XXXDataOperations with 2 Enum values: Select, Delete, Update
When you execute the class, you will get dialog like below:
This was originally posted here.
*This post is locked for comments