BAQDataView on Multi Resource Scheduling Board

Hello all,

In a customization for the classic multi resource scheduling board, I am able publish/subscribe the column resourceList.ResourceID to my BAQ’s column JobOpDtl_ResourceID and it is working as intended.

How do I go about getting more than 1 ResourceID to populate in my BAQDataView when I add in more resources in the selection tab?

‘’’
using System;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Windows.Forms;
using Erp.Adapters;
using Erp.UI;
using Ice.Lib;
using Ice.Adapters;
using Ice.Lib.Customization;
using Ice.Lib.ExtendedProps;
using Ice.Lib.Framework;
using Ice.Lib.Searches;
using Ice.UI.FormFunctions;

public class Script
{
// ** Wizard Insert Location - Do Not Remove ‘Begin/End Wizard Added Module Level Variables’ Comments! **
// Begin Wizard Added Module Level Variables **
BAQDataView bdvMyBAQ;
// End Wizard Added Module Level Variables **

// Add Custom Module Level Variables Here **

public void InitializeCustomCode()
{
	// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **
	// Begin Wizard Added Variable Initialization

	// End Wizard Added Variable Initialization

	// Begin Wizard Added Custom Method Calls
	SetupQueryList();
	// End Wizard Added Custom Method Calls
}

public void DestroyCustomCode()
{
	// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Object Disposal' lines **
	// Begin Wizard Added Object Disposal

	// End Wizard Added Object Disposal

	// Begin Custom Code Disposal

	// End Custom Code Disposal
}
public void SetupQueryList()
{
	bdvMyBAQ = new BAQDataView("ahMRSBGrid");
	oTrans.Add("ahMRSBGrid", bdvMyBAQ);

	var fromPBBinding = "resourceList.ResourceID";
	oTrans.PublishColumnChange(fromPBBinding,"resourceListResourceIDPub");

	var fromPub = oTrans.GetPublisher(fromPBBinding);
	bdvMyBAQ.SubscribeToPublisher(fromPub.PublishName,"JobOpDtl_ResourceID");
}

}
‘’’

Publish/Subscribe is even easier in Kinetic. I know this isn’t a dashboard but should work the same. @hmwillett has a great thread on Kinetic dashboards How To: Kinetic Dashboard Uplifts I used that for upgrading ours.

1 Like

Hey Randy, thank you for this, I will use this if we plan to upgrade to kinetic. Currently still on E10 using non kinetic screens.

1 Like

Sorry, I read your question like an upgrade to Kinetic as we’re in the middle of moving to the new UI.

I ended up recreating the list in multi resource scheduling board as a BAQ and using a button to run the baq passing in the resource ids in a list as a parameter to the baq.