Binding BAQDataView to epiUltraGrid not adding columns

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

	public void CreatePaymentHistBAQView()
		baqViewPaymentHist = new BAQDataView("InvoicePaymentHistCustomer");

		string pubBinding = "Customer.CustID";
		IPublisher pub = oTrans.GetPublisher(pubBinding);

			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.

They should be there once you save / close re-open did you do that already?

Yup! … I had thought I saved, closed CustTracker, and re-opened… This time I closed Epicor completely, and now it’s there. Hah! Leaving this post here anyways. Doh. :slight_smile: