Standard Directive - Table has multiple rows


usable in in trans & std

ok. heres what we have.

if( callContextBpmData.Character01.EndsWith(“|”) )
callContextBpmData.Character01 = callContextBpmData.Character01.Remove(callContextBpmData.Character01.Length - 1);

List rowsList = callContextBpmData.Character01.Split(‘|’).ToList();

callContextBpmData.Character01 = “”;

foreach(var rowStringJson in rowsList)

MtlQueueTempRow myRow = JsonConvert.DeserializeObject(rowStringJson);


I imagine this is what you mean by knowing how to deserialize it properly?


I got you a skeleton, hold one.


  //using Newtonsoft.Json;

  //This is probably all you need to do in-trans, unless you need to add conditions
  //Of course, if you do need conditions, you could filter later in the standard too
  callContextBpmData.Character01 += JsonConvert.SerializeObject(ttMtlQueue.First()) + "|";


  //using Newtonsoft.Json;

  List<string> rowsList = callContextBpmData.Character01.Split("|").ToList();
  callContextBpmData.Character01 = "";
  foreach(string rowJson in rowsList)
      Erp.Bpm.TempTables.MtlQueueTempRow rowToProcess = JsonConvert.DeserializeObject<Erp.Bpm.TempTables.MtlQueueTempRow>(rowJson);
      //Now you can do work with the row...
      var jobNum = rowToProcess.JobNum; //etc
      //Do whatever work you wanted to do before...
1 Like

I have this working.
It is now posting to the API should the record end up making it to the standard Directive update!

I have some other issues but this is for the guys who programmed the function i am hooking onto.

Thank you for this.

1 Like

I lost some brain cells, so I’ll have a few beers and celebrate by losing some more. :beers:

Hi, I’m still having issues with sporadic material queue records.

I have the following row but the Standard directive does not fire after the in transaction runs, this is an output from the in-transaction.

The whole bpm works with every majority of records.

callContextBpmData.Character01 {“RowMod”:“A”,“Company”:“LIFT”,“SysDate”:“2023-03-09T00:00:00”,“SysTime”:49973,“MtlQueueSeq”:90918,“Plant”:“MfgSys”,“PartNum”:“00000”,“Quantity”:25.00000000,“TranType”:“STK-SHP”,“ReferencePrefix”:“SO:”,“Reference”:“918301/6/1”,“RequestedByEmpID”:“”,“SelectedByEmpID”:“”,“JobNum”:“”,“AssemblySeq”:0,“JobSeqType”:“M”,“JobSeq”:0,“FromWhse”:“NDC”,“FromBinNum”:“CAR01”,“ToWhse”:“SHIP”,“ToBinNum”:“SHIP”,“NextAssemblySeq”:0,“NextJobSeq”:0,“NeedByDate”:“2023-02-23T00:00:00”,“NeedByTime”:49973,“VendorNum”:0,“PurPoint”:“”,“PackSlip”:“”,“PackLine”:0,“OrderNum”:918301,“OrderLine”:6,“OrderRelNum”:1,“TargetJobNum”:“”,“TargetAssemblySeq”:0,“TargetMtlSeq”:0,“RevisionNum”:“”,“PartDescription”:“7W Firestay LED CCT Downlight - Dim, P&P, 3 Colour, 40°”,“IUM”:“EA”,“PONum”:0,“POLine”:0,“PORelNum”:0,“Visible”:true,“RMANum”:0,“RMALine”:0,“RMAReceipt”:0,“RMADisp”:0,“NCTranID”:0,“LotNum”:“”,“Lock”:false,“QueueID”:“”,“QueuePickSeq”:0,“ReleaseForPickingSeq”:13288,“WhseGroupCode”:“”,“TranStatus”:“RELEASED”,“WaveNum”:0,“Priority”:3,“TranSource”:“”,“LastMgrChangeEmpID”:“2177”,“AssignedToEmpID”:“”,“TargetTFOrdNum”:“”,“TargetTFOrdLine”:0,“PackStation”:“”,“DistributionType”:“HANDHELD”,“Obs10_PkgNum”:0,“Obs10_PkgLine”:0,“SysRevID”:“AAAAAAiuIno=”,“SysRowID”:“2750a609-6f33-4c07-9191-0df9fc7ef1a9”,“PCID”:“USE-FROMPCID-TOPCID”,“EpicorFSA”:false,“LastUsedPCID”:“”,“FromPCID”:“”,“ToPCID”:“”,“AttributeSetID”:0,“AttributeValueSeq”:0,“NumberOfPieces”:0,“UD_SysRevID”:“AAAAAAiuIns=”,“WhseSplit_c”:“”,“WhseSplitNum_c”:0,“EntityKey”:null}|

Are you positive it’s not firing, or some other failure?

On the Standard Directive I only have a code block which posts a string to the event logs so i know if it its triggered and it doesn’t for some records.

I also have the same post to event viewer with a different string just before the Enable Standard Directive widget. which writes everytime.

Next question, are you sure that record was written to the DB ?

As in, it succeeded.

yes, it exists in the Material Queue ready for processing.

1 Like

It’s possible the call context won’t work for this, or we’ve overlooked something.

I have a few other options, I will think on it.

thank you.


I have another possible solution around this.
Create a CSV file of all records (based on FromBinNum = x or y) in the Material Queue (using a function on a schedule)
This would have to be date and time dependent as records will arrive in the material queue in batches.

I am unsure how big of a task this is and exactly how to do this.

sorry for the spam but i could create a BAQ export as CSV and run that on a schedule.
the only problem with this is each export has to have the same file name.

No problem dude, I got an idea, just got to finish forming it.


sweet, thanks.

Before I help him with a workaround, is there anybody who knows why
a standard directive wouldn’t fire even though the in-trans did, and was successful?

This definitely solved the problem.

My issue was i had another Epicor function running that stops the Standard Directive firing for some unknown reason.

Workaround was simple and works a treat :slight_smile:

Thank you.

1 Like