Here’s an example video of how to do a BAQ dataview.
BAQ Dataviews are a great way to view related data onto a screen in Epicor. If you can link the data on the screen to the data you want to display in a BAQ you can display it. They are faster and more flexible than FKVs or embedded dashboards.
and the code.
public void CreateOrderLineOnHandBAQDV()
{
orderLineOnHandBAQDV = new BAQDataView("OrderLineOnHand");
oTrans.Add("OrderLineOnHandBAQDV",orderLineOnHandBAQDV);
string pub1Binding = "OrderDtl.OrderNum";
IPublisher pub1 = oTrans.GetPublisher(pub1Binding);
if(pub1==null)
{
string pubName = Guid.NewGuid().ToString();
oTrans.PublishColumnChange(pub1Binding, pubName);
pub1 = oTrans.GetPublisher(pub1Binding);
}
if(pub1 !=null)
orderLineOnHandBAQDV.SubscribeToPublisher(pub1.PublishName, "OrderDtl_OrderNum");
string pub2Binding = "OrderDtl.OrderLine";
IPublisher pub2 = oTrans.GetPublisher(pub2Binding);
if(pub2==null)
{
string pubName = Guid.NewGuid().ToString();
oTrans.PublishColumnChange(pub2Binding, pubName);
pub2 = oTrans.GetPublisher(pub2Binding);
}
if(pub2 !=null)
orderLineOnHandBAQDV.SubscribeToPublisher(pub2.PublishName, "OrderDtl_OrderLine");
}