What do you mean a before and after record for the expected change?
I do see that in the ChangeFromWarehouse method the pre processing dataset is only one set of data and then the post processing the dataset is duplicated, once with the before values and once with the changed.
However, I also noticed that in the preprocessing dataset, the rowmod is “u”.
I see that the dataset before all of this doesn’t have a rowmod value… could this be my problem? Do I need to edit the dataset and add a value there before passing it to the ChangeFromWarehouse method? I will see what I can do here. Can I do this with a widget?
Pre Processing
XYZ,5/6/2021 12:00:00 AM,MI-E2,D - East Coater D Area,MI-E2,D - East Coater D Area,D1,Warehouse D Bin 1,0,0,MfgSys,MfgSys,03-102,False,False,True,partdesc,something,MfgSys,False,MfgSys,False,GL,0,GL,GL,GL,0,0,0,0,False,0,0,0,0,eadcb3dc-e0a9-40bf-9ebd-1c969ef45872,U
Post Processing
XYZ,5/6/2021 12:00:00 AM,MI-E2,D - East Coater D Area,MI-E2,D - East Coater D Area,D1,Warehouse D Bin 1,D1,Warehouse D Bin 1,0,0,MfgSys,MfgSys,03-102,False,False,True,partdesc,something,MfgSys,False,MfgSys,False,GL,0,GL,GL,GL,0,0,0,0,False,0,0,0,0,eadcb3dc-e0a9-40bf-9ebd-1c969ef45872,
XYZ,5/6/2021 12:00:00 AM,MI-E1,F - East Large Raw,MI-E2,D - East Coater D Area,FW05,Warehouse F Bin FW05,D1,Warehouse D Bin 1,1014.39000000,0,MfgSys,MfgSys,03-102,False,False,True,partdesc,something,MfgSys,False,MfgSys,False,GL,0,GL,GL,GL,0,0,0,0,False,0,0,0,0,eadcb3dc-e0a9-40bf-9ebd-1c969ef45872,
EDIT Thank you @NateS for showing me the message widget with table query. I was able to identify that I needed to update the dataset and add a rowmod value of “u” before passing the dataset to the changefromwarehouse method.