Oct 19, 2023

How to update a temp table column in D365 FO

 [ExtensionOf(classStr(AssetRollForwardDP))]

final class AssetRollForwardDP_My_Extension

{

 //  Overriding getAssetRollForwardTmp() as it is returning the temp table buffer.

 public AssetRollForwardTmp getAssetRollForwardTmp(AssetRollForwardContract _contract, Query _query)

    {

        AssetRollForwardTmp assetRollForwardTmpUpd;        

        AssetTable      assetTableBuf;         

        next  getAssetRollForwardTmp(_contract, _query);   

        assetRollForwardTmpUpd.linkPhysicalTableInstance(assetRollForwardTmp);

               

        update_recordset assetRollForwardTmpUpd

            setting 

                AssetName = assetTableBuf.AdditionalName

            join AdditionalName from assetTableBuf

            where assetRollForwardTmpUpd.assetid == assetTableBuf.AssetId;


        return assetRollForwardTmp;

    }


}

No comments: