BPM, passing multiple parameters to a BAQ

Kinetic ERP
,
1

Hello, I’m trying to find a way to pass multiple parameters to a BAQ and get the results back. I’ve only had to do one in the past, which I accomplished with widgets.
By getting the executionParameters, Updating the ID/Value of the parameter, giving the BAQ the executionParametersDataset, and then pulling the returned value using code. (See below)
image

image
image1008×606 44.8 KB

image
image1037×640 62.3 KB

image
image1031×622 50.4 KB

image

Now I need to use a BAQ that has three different Parameters. I couldn’t figure out a way to do it using the same method, so I’ve tried doing this:

var paramRow1 = FirstQueryParams.ExecutionParameter.NewRow();

paramRow1[“ParameterID”] = “jobnum”;
paramRow1[“ParameterValue”] = jobnum;
paramRow1[“ValueType”] = “nvarchar”;
paramRow1[“IsEmpty”] = false;
paramRow1[“RowMod”] = “U”;
paramRow1[“SysRowID”] = Guid.Empty;
FirstQueryParams.ExecutionParameter.Add(paramRow1);
Epicor.Customization.Bpm.InfoMessage.Publish(“set first as” + jobnum + “.”);

var paramRow2 = FirstQueryParams.ExecutionParameter.NewRow();
paramRow2[“ParameterID”] = “opcode”;
paramRow2[“ParameterValue”] = opcode;
paramRow2[“ValueType”] = “nvarchar”;
paramRow2[“IsEmpty”] = false;
paramRow2[“RowMod”] = “U”;
paramRow2[“SysRowID”] = Guid.Empty;
FirstQueryParams.ExecutionParameter.Add(paramRow2);
Epicor.Customization.Bpm.InfoMessage.Publish(“set sec as” + opcode + “.”);

var paramRow3 = FirstQueryParams.ExecutionParameter.NewRow();
paramRow3[“ParameterID”] = “oprseq”;
paramRow3[“ParameterValue”] = oprseq;
paramRow3[“ValueType”] = “nvarchar”;
paramRow3[“IsEmpty”] = false;
paramRow3[“RowMod”] = “U”;
paramRow3[“SysRowID”] = Guid.Empty;
FirstQueryParams.ExecutionParameter.Add(paramRow3);
Epicor.Customization.Bpm.InfoMessage.Publish(“set th as” + oprseq + “.”);

image
I get the executionparametersdataset in the same way as before, then execute that code, then invoke the BAQ as before, and try to pull hours. It seems to take the parameters, but it returns 0 for all values… but if i type the values in manually I get the actual results(In the BAQ itself)

image
image803×423 21.1 KB

all 3 are nvarchars, and all 3 are strings inside of the BPM…

Any ideas?

2

This is not exactly what you asked for, but I have passed parameters to a BAQ from a customized form. In C# I customized the form with this code:

private void CheckForCheckedOut()
	{
	//If this part/rev is checked out to the current user's eco group, then display warning.
		EpiDataView edv = (EpiDataView)this.oTrans.EpiDataViews["CallContextClientData"];
		string myUserString = edv.dataView[0]["CurrentUserId"].ToString();
		DynamicQueryAdapter dqa = new DynamicQueryAdapter(oTrans);
		dqa.BOConnect();		
		QueryExecutionDataSet qeds = dqa.GetQueryExecutionParametersByID("getPartRevECOs");
		qeds.ExecutionParameter.Clear();
		qeds.ExecutionParameter.AddExecutionParameterRow("part", txtMyPart.Text, "nvarchar", false, Guid.NewGuid(), "A");
		qeds.ExecutionParameter.AddExecutionParameterRow("rev", revCombo.Text, "nvarchar", false, Guid.NewGuid(), "A");
		qeds.ExecutionParameter.AddExecutionParameterRow("ECOGroup", myUserString, "nvarchar", false, Guid.NewGuid(), "A");
		dqa.ExecuteByID("getPartRevECOs", qeds);
		if (dqa.QueryResults.Tables["Results"].Rows.Count > 0)
		{
		// This part is checked out! Flag the screen and show the warning.
			lblCheckedOutWarning.Visible = true;
		}
		else
		{
			lblCheckedOutWarning.Visible = false;
		}
	}

I am not sure if that will help with your BPM, but it is possible! I think the important part here is that my BAQ (getPartRevECOs) already has the three parameters required. This code just sets the values for those parameters. The main difference I can see is that you are using “U” to update the parameter row, and I used “A” to add the parameter row.
Good luck!

1 Like
4

Write a function which has your parameters as signatures.

Call the BAQ in c# custom code.

Return the results via bpm.

I have some code here that will get you started. I will post it tomorrow.

3 Likes
5

I ended up figuring it out using just the widgets, when I was setting the query, I changed the parameterID to the two other ones, and set the values seperately, so its basically just three update row widgets to get the correct parameters.

4 Likes