Showing posts with label Temp Records Update in D365 FO. Show all posts
Showing posts with label Temp Records Update in D365 FO. Show all posts

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;

    }


}