I got inspired at Insights (Customization to the Max - Client seminar) this year, and tried to replace a dashboard sheet on Customer Tracker with a BAQ Data View.
I followed Jose’s fantastic tutorial Efficiently Adding Column to DataGrid to link the BAQ to a data view, but don’t see the columns in the BAQ when I click the (Collection) arrow. What did I miss?
I added a sheet with the sheet wizard, and then with tools, dropped the epiUltraGrid. I figured once I set the binding to the BAQ Data View, the columns would populate, but they didn’t.
Here’s a chunk of the script editor where I followed Jose’s video:
using Ice.Lib.Broadcast;
public class Script
{
// ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **
// Begin Wizard Added Module Level Variables **
private string IDCurrent = "";
private EpiDataView edvCustomer;
internal System.Drawing.Color ColorHover = System.Drawing.Color.LightSkyBlue;
internal System.Drawing.Color ColorTextHover = System.Drawing.Color.White;
internal System.Drawing.Color ColorAlternating = System.Drawing.Color.Azure;
// End Wizard Added Module Level Variables **
// Add Custom Module Level Variables Here **
BAQDataView baqViewPaymentHist;
public void InitializeCustomCode()
{
// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **
// Begin Wizard Added Variable Initialization
this.CustomerTrackerForm.Shown += new System.EventHandler(this.FormShown);
this.edvCustomer = ((EpiDataView)(this.oTrans.EpiDataViews["Customer"]));
this.edvCustomer.EpiViewNotification += new EpiViewNotification(this.edvCustomer_EpiViewNotification);
// End Wizard Added Variable Initialization
// Begin Wizard Added Custom Method Calls
this.callCustBtn.Click += new System.EventHandler(this.callCustBtn_Click);
// End Wizard Added Custom Method Calls
CreatePaymentHistBAQView();
}
public void CreatePaymentHistBAQView()
{
baqViewPaymentHist = new BAQDataView("InvoicePaymentHistCustomer");
oTrans.Add("BAQ_InvoicePaymentHistCustomer",baqViewPaymentHist);
string pubBinding = "Customer.CustID";
IPublisher pub = oTrans.GetPublisher(pubBinding);
if(pub==null)
{
oTrans.PublishColumnChange(pubBinding, "MyCustomPublish");
pub = oTrans.GetPublisher(pubBinding);
}
if(pub !=null)
baqViewPaymentHist.SubscribeToPublisher(pub.PublishName, "Customer_CustID");
}
Great seeing everyone again this year, and thanks for helping too.