Change Resource Group ID for Open Jobs

[NateS (Nate Schoonover)]

I found a slightly modified version of this code that seems to work well. I found it here:

Passing Parameter/Filter in Dynamic Query

Just to clarify, the method I was outlining is a lot of code, but it does do exactly what you want. We’ve standardised a lot of it to do what we need and now build most of our dashboards this way because it turns out to be more flexible and maintainable in the long run. Step 1. Build and deploy a dashboard with a near-empty dummy BAQ, no grid view and one full-screen tracker view with no fields. That gives you a blank canvas. Step 2. Create a customization for the blank dashboard. Use the stan…

private void epiButtonC1_Click(object sender, System.EventArgs args)
	{
	// ** Place Event Handling Code Here **
	
	DynamicQueryAdapter yourbaq = new DynamicQueryAdapter(this.oTrans);
	DataTable results;
	yourbaq.BOConnect();
	string baqname = "ChangeOpenJobResGrpIDs";
	Ice.BO.QueryExecutionDataSet dsBAQ = yourbaq.GetQueryExecutionParametersByID(baqname);
	dsBAQ.ExecutionParameter[0].ParameterID = "OldResGrpID";
	dsBAQ.ExecutionParameter[0].IsEmpty = false;
	dsBAQ.ExecutionParameter[0].ParameterValue = epiTextBoxC1.Value.ToString();
	dsBAQ.AcceptChanges();
	yourbaq.ExecuteByID(baqname, dsBAQ);
	
	// Set results of query to the grid view
	epiUltraGridC1.DataSource=yourbaq.QueryResults.Tables["Results"].DefaultView;
	}

This works great so far. Thanks Daryl! I will get on the update portion next.