BAQ Data View with Parameters

Epicor ERP 10
1

I am creating a BAQ DataView which subscribes to another custom data view. I would like to put parameters to my BAQ DataView Query so I can limit the results. Right now it is finding all of our orders and we are up to 600,000 orders in our system so the query takes a bit. How can I add two parameters to my GS_Order_Detail_DataView BAQ?
The Publisher View:

	private void OrderPublisherView()
	{
	DataTable dt1 = new DataTable();
	dt1.Columns.Add(new DataColumn("OrderNum",typeof(string)));
	dt1.Columns.Add(new DataColumn("OrderLine", typeof(string)));
	dt1.Columns.Add(new DataColumn("OrderPONum", typeof(string)));
	dt1.Columns.Add(new DataColumn("SysRowID",typeof(Guid)));
	var r = dt1.NewRow();
	dt1.Rows.Add(r);
	EpiDataView edvMyCustomOrderDV = new EpiDataView();
	edvMyCustomOrderDV.dataView = dt1.DefaultView;
	oTrans.Add("MyCustomOrderView",edvMyCustomOrderDV);
	}

The Dataview that subscribes to it in which I want to add paramerters into the BAQ Query.

//Order - Order Data View
private void CreateOrderBAQView() 
	{
	GS_Order_Detail_DataView = new BAQDataView("GS_Order_Detail_DataView");
	oTrans.Add("GS_Order_Detail_DataView", GS_Order_Detail_DataView);
	var OrderNum = "MyCustomOrderView.OrderNum";
	var OrderLine = "MyCustomOrderView.OrderLine";
	oTrans.PublishColumnChange(OrderNum, Guid.NewGuid().ToString());
	oTrans.PublishColumnChange(OrderLine, Guid.NewGuid().ToString());
	var OrderNumPub = oTrans.GetPublisher(OrderNum);
	var OrderLinePub = oTrans.GetPublisher(OrderLine);
	GS_Order_Detail_DataView.SubscribeToPublisher(OrderNumPub.PublishName, "OrderDtl_OrderNum");
	GS_Order_Detail_DataView.SubscribeToPublisher(OrderLinePub.PublishName, "OrderDtl_OrderLine");
	}
2

You can use a RowFilter on the dataView property of your data view to provide a filter.
it uses SQL-like syntax

foreach (DataRowView drv_iterator in edvOrderDtl.dataView)
{	
  DataRowView drv = drv_iterator;
  string orderNum = drv["OrderNum"].ToString();
  string orderLine = drv["OrderLine"].ToString();
  if (drv != null)
  {
    edvOrderRel.dataView.RowFilter = "OrderNum = orderNum and OrderLine = orderLine";				
  }
}
3

Bumping this as Im also interested to know how to do. TIA