Update Table Field using Script Editor in Customization

Epicor ERP 10
, ,
1

Hello,
I’ve been sucessfully using the following BPM inside an UBAQ to update a User Field (Checkbox01) in the PartSug table. Basically the user checks the box in the Dashboard and after saving it writes directly to the Table.

Instead of using an UBAQ BPM, is there a way to code this inside Script Editor in the Dashboard’s Customization? Is there a way to translate this BPM to Script Editor?

I’ve used BOConnect in the past, but cannot find a BO that updates the PartSug table.

Thanks

using (System.Transactions.TransactionScope transactionScope = IceDataContext.CreateDefaultTransactionScope())
{
  
    var ttResultQuery = ttResults
        .Where(row => !string.IsNullOrEmpty(row.RowMod) && row.RowMod != "P");

    foreach (var ttResult in ttResultQuery)
    {
      
     var dsPartSug = (from tt in Db.PartSug where 
     tt.Company == ttResult.PartSug_Company &&
     tt.TargetJobNum == ttResult.PartSug_TargetJobNum &&
     tt.TargetAssemblySeq == ttResult.PartSug_TargetAssemblySeq &&
     tt.TargetMtlSeq == ttResult.PartSug_TargetMtlSeq &&
     tt.Classifier == ttResult.PartSug_Classifier &&
     tt.OrderNum == ttResult.PartSug_OrderNum &&
     tt.OrderLine == ttResult.PartSug_OrderLine &&
     tt.OrderRelNum == ttResult.PartSug_OrderRelNum &&
     tt.WarehouseCode == ttResult.PartSug_WarehouseCode &&
     tt.PartNum == ttResult.PartSug_PartNum &&
     tt.DueDate == ttResult.PartSug_DueDate &&
     tt.JobNum == ttResult.PartSug_JobNum &&
     tt.AssemblySeq == ttResult.PartSug_AssemblySeq &&
     tt.JobSeq == ttResult.PartSug_JobSeq &&
     tt.SugNum == ttResult.PartSug_SugNum select tt).FirstOrDefault();
    
     if (dsPartSug != null)
    {
      dsPartSug.CheckBox01 = ttResult.PartSug_CheckBox01;
    }
     
     }   
     
     this.Db.Validate();
     transactionScope.Complete();
}
2

All the ways I can think of still come back to a BPM of some kind (or Function).