# Dashboard Pass Silent Parameters to Updatable BAQ

**URL:** <https://www.epiusers.help/t/dashboard-pass-silent-parameters-to-updatable-baq/94732>\
**Category:** Kinetic ERP\
**Tags:** baq\
**Created:** [September 27, 2022, 11:00am UTC](https://www.epiusers.help/t/dashboard-pass-silent-parameters-to-updatable-baq/94732 "2022-09-27T11:00:06Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\
**Post date:** [September 27, 2022, 11:00am UTC](https://www.epiusers.help/t/dashboard-pass-silent-parameters-to-updatable-baq/94732/1 "2022-09-27T11:00:06Z")

</div>

@pferrington @Epic_Santiago If you recall in 10.2.600 you delivered this amazing feature, and I’ve been using it, abusing it and overusing it!

> [@Dashboard Pass Silent Parameters to BAQ](https://www.epiusers.help/t/dashboard-pass-silent-parameters-to-baq/46319):
>
> A Feature asked for ages; never delivered by Epicor yet it seems like a simple one… In a Dashboard allow Passing in Parameters to the BAQ Before Execution so we can stop running wide-open BAQs which hammer the server because Post-Filtering is not the answer. Example: Click on Parent Grid and have the Child Re-Run BAQ with specific Params. So if you are doing lets say CTEs Recursive or Sub-Queries and SUM() and MAX() you will get “accurate” number with little effort because each time the BAQ wil…

However, it doesn’t work with an **Updatable BAQ** if I feed it params it keeps prompting for params. Do you have anything in your backlog to fix that bug or feature? If not, how can I push for it.

_I think the only workaround now is to make a BPM on UBAQ under GetList and use BpmData to fill them in_  
 ![image](https://www.epiusers.help/uploads/default/original/3X/0/6/06a20753ee3ecb9f6d26628fc0a2a45a5bb89168.png)

BTW Thank You for also giving us the ability to pass Silent Params via BAQDataView. I’ve been using that as well 🙂

```cs
public void CreateBAQDV()
{
	// Set up the BAQ(s) to be Called
	MaterialBAQDV = new BAQDataView("CODE-IssuedExMaterial");
	OperationBAQDV = new BAQDataView("CODE-IssuedExOperation");

	// Add BAQ DataViews to the oTrans
	oTrans.Add("MaterialBAQDV", MaterialBAQDV);
	oTrans.Add("OperationBAQDV", OperationBAQDV);

	// Set up the Strings (Field to Monitor, New Guid string, BAQ Parameter name)
	Tuple<string, string, string>[] publishers =
	{
		Tuple.Create("PartTran.JobNum", Guid.NewGuid().ToString(), "JobNum"),
		Tuple.Create("PartTran.AssemblySeq", Guid.NewGuid().ToString(), "AssemblySeq"),
		Tuple.Create("PartTran.ActTranQty", Guid.NewGuid().ToString(), "ChangeQty"),
		Tuple.Create("PartTran.DispUOM", Guid.NewGuid().ToString(), "OriginalUOM"),
		Tuple.Create("PartTran.ActTransUOM", Guid.NewGuid().ToString(), "ChangeUOM"),
		Tuple.Create("PartTran.PartNum", Guid.NewGuid().ToString(), "PartNum")
	};

	// Set up the Publisher Columns with the Guids
	IPublisher pub1 = oTrans.GetPublisher(publishers[0].Item1);
	if (pub1 == null)
	{
		foreach (var row in publishers)
		{
			oTrans.PublishColumnChange(row.Item1, row.Item2);
		}
	}

	// Add the BAQ Parameters(BAQ Parameter Name, Comment, GUID Associated with the PublishColumnChange
	foreach (var row in publishers)
	{
		this.MaterialBAQDV.AddBAQParameter(new BAQViewParameter(row.Item3, "", row.Item2));
		this.OperationBAQDV.AddBAQParameter(new BAQViewParameter(row.Item3, "", row.Item2));
	}
}

```

---

<div class="post-metadata">

**Author:** ![Epic\_Santiago](https://www.epiusers.help/letter_avatar_proxy/v4/letter/e/3d9bf3/32.png) [@Epic\_Santiago](https://www.epiusers.help/u/Epic_Santiago)\
**Post date:** [September 27, 2022, 3:40pm UTC](https://www.epiusers.help/t/dashboard-pass-silent-parameters-to-updatable-baq/94732/2 "2022-09-27T15:40:21Z")

</div>

Glad to hear you are enjoying the silent parameters. BAQs are not my area of expertise so I’ll defer to Patrick.  
I would say if there is nothing in the backlog then enter an Epicor Idea for it. Alternatively, enter an enhancement request with support.

---

<div class="post-metadata">

**Author:** ![pferrington](https://www.epiusers.help/user_avatar/www.epiusers.help/pferrington/32/9723_2.png) [@pferrington](https://www.epiusers.help/u/pferrington)\
**Post date:** [September 28, 2022, 2:51pm UTC](https://www.epiusers.help/t/dashboard-pass-silent-parameters-to-updatable-baq/94732/3 "2022-09-28T14:51:42Z")

</div>

You should entire an Idea for it. That is always safest but if time allows I’ll look into it.

---

<div class="post-metadata">

**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\
**Post date:** [September 28, 2022, 2:57pm UTC](https://www.epiusers.help/t/dashboard-pass-silent-parameters-to-updatable-baq/94732/4 "2022-09-28T14:57:53Z")

</div>

Oki will do, wanted to make sure you werent already working on it.

---

<div class="post-metadata">

**Author:** ![Stevensi1018](https://www.epiusers.help/user_avatar/www.epiusers.help/stevensi1018/32/63142_2.png) [@Stevensi1018](https://www.epiusers.help/u/Stevensi1018)\
**Post date:** [October 27, 2022, 6:45pm UTC](https://www.epiusers.help/t/dashboard-pass-silent-parameters-to-updatable-baq/94732/5 "2022-10-27T18:45:10Z")

</div>

Have you found a solution for this? I tried to use your code in the Pre Processing in GetList in the Updateable BAQ but ttExecutionParameter is not defined and I’m not sure how I can add values from there

That’s good to know that it wasn’t working because my BAQs are updateable, I was going crazy trying to find what I did differently than the last time I used the functionnality !

I tried this but for some reason, the parameter is not set to value I set:  
In the Parent BAQ (Which is updateable):  
Add a POST Processing Method on the GetList with this code

```auto
var row = executionParams.ExecutionParameter.First(r => r.ParameterID == "ProjectID");
if(row != null)
   callContextBpmData.Character01 = row.ParameterValue;

```

In the Child BAQ (Which must be updateable):  
Add a PRE Processing Method on the GetList with this code

```auto
var row = executionParams.ExecutionParameter.First(r => r.ParameterID == "ProjectID");
if(row != null)
  row.ParameterValue = callContextBpmData.Character01;

```

The problem with that is that the GetList is called after the pop-up window it seems

---

<div class="post-metadata">

**Author:** ![mbilodeau](https://www.epiusers.help/user_avatar/www.epiusers.help/mbilodeau/32/40061_2.png) [@mbilodeau](https://www.epiusers.help/u/mbilodeau)\
**Post date:** [September 8, 2023, 12:08am UTC](https://www.epiusers.help/t/dashboard-pass-silent-parameters-to-updatable-baq/94732/6 "2023-09-08T00:08:37Z")

</div>

> [@hkeric.wci](#):
>
> the ability to pass Silent Params via BAQDataView

Great stuff. Is this piece of code only available on 10.2.600 and later ?