E10 BPM Slow due to Join?

Epicor ERP 10
42 
public void CreateTotalBilledBAQView()
	{
		baqViewTotalBilled = new BAQDataView("TotalOrdTotalInvByShipToNum");
		oTrans.Add("TotalBilledBAQ",baqViewTotalBilled);

		string pubBinding = "ShipTo.ShipToNum";
		IPublisher pub = oTrans.GetPublisher(pubBinding);
		if(pub == null)
		{
			oTrans.PublishColumnChange(pubBinding, "MyCustomPublish");
			pub = oTrans.GetPublisher(pubBinding);
		}

		if(pub != null)
			baqViewTotalBilled.SubscribeToPublisher(pub.PublishName, "TotalOrdTotalInvByShipToNum_ShipToNum");
	}

PS I found a video on YouTube that happened to be made by you a few years ago and used that code as a template :stuck_out_tongue:

The only other publisher I would add is Customer.CustID

1 Like
43

So do that again for CustNum
Just add another pubBinding and another call to subsscribeToPublisher

44

I love this.

image

45

So maybe I am missing something huge, but is there a way around this?

Like say I have a temp table and I want to join a Db table to it to do some sort of data validation logicā€¦ is it simply we just canā€™t do this in any way shape or form?

46

Instead of a join, do it in the table filter. It will work better.

1 Like