BAQ Dashboard Tracker

Kinetic ERP
, ,
1

We have a column in our dashboard with room numbers. We also have a column that looks at the first digit of the room number which is the floor number. Is there a way to add a tracker for the floor number column where we can search multiple numbers non sequentially. So if we could type in say: “1,3,5” it will pull all rows that have room numbers starting with those digits.

2

You can extract that “floor number” into a calculated field in the BAQ. Then you can filter on it like any other field.

3

Well that’s what I did, but what if we want to show multiple floor room numbers? Can you filter on multiple values? I guess without doing a custom filter on the column to show multiple. Just a textbox where we could enter multiple string values

4

Is creating the filter in the BAQ out of the question? You can do a list filter parameter. I think your approach is totally possible with a bit of custom code. Just trying to avoid that if possible.

1 Like
5

So in the list filter parameter do I just need to add all the possible room number options first? Then in the textbox in the tracker I should be able to enter multiple values? Also, where exactly does the list filter parameter get added?

6

No, the parameter method would be if you don’t use the tracker text box. You just update the floors you want each time you refresh the BAQ. If you don’t want to do it this way (understandable), then you will need to use the dynamic query adapter to add parameters to your BAQ from the tracker at runtime.

Here are some key code tidbits, but you may have to do some research to connect the dots. This is something I copied from @hkeric.wci at some point.

//
// Epicor 10.1 Calling BAQ from C# Sample by Haso Keric
//
// If you have seen and are using the following in your BAQ Call:
// QueryExecutionDataSet q = dynamicQuery.GetQueryExecutionParametersByID("BAQ_NAME");
// q.ExecutionParameter.Clear();
//
// There is really no need. That is if you are working with multiple methods or you would like to check for possible params
// It makes absolutely no sense to Get The Params only to Clear them. Because you end up adding Param // Rows again anyways.
//
 
 
// Execute a BAQ by Calling the Business Object via WCF
private void CallBAQUsingBO()
{
	try
	{
		// Declare and Initialize Variables
		string BAQName = "DIEN-HASO";
		Ice.BO.QueryExecutionDataSet ds = new Ice.BO.QueryExecutionDataSet();
 
		// Add Parameter Rows
		// Definition: AddExecutionParameterRow(string ParameterID, string ParameterValue, string ValueType, bool IsEmpty, Guid SysRowID, string RowMod)
		// Possible ValueTypes: nvarchar, int, decimal, date, datetime, bit, uniqueidentifier, bigint
		// IsEmpty indicates if your passed value Is Empty because if it is, you can define in your params to use a default value if empty.
		// Typically you use string.IsNullOrEmpty(yourValueVariable) but if you are hard coding a value then you can simply set it to false
		ds.ExecutionParameter.AddExecutionParameterRow("QuoteNumber", "10003", "int", false, Guid.Empty, "A");
		ds.ExecutionParameter.AddExecutionParameterRow("FirstName", "Bill", "nvarchar", false, Guid.Empty, "A");
 
		// Use Business Object Directly
		Ice.Proxy.BO.DynamicQueryImpl dynamicQuery = WCFServiceSupport.CreateImpl<Ice.Proxy.BO.DynamicQueryImpl>((Ice.Core.Session)oTrans.Session, Epicor.ServiceModel.Channels.ImplBase<Ice.Contracts.DynamicQuerySvcContract>.UriPath);
		System.Data.DataSet results = dynamicQuery.ExecuteByID(BAQName, ds);
 
		// Lets Loop through our results
		if (results.Tables["Results"].Rows.Count > 0)
		{
			foreach (DataRow item in results.Tables["Results"].Rows)
			{
				// In E9 you used TableName.Column in E10 it is TableName_Column
			    string val = item["QuoteHed_QuoteNum"].ToString();
			}
		}
	} catch (System.Exception ex)
	{
		ExceptionBox.Show(ex);
	}
}
 
 
// Execute a BAQ by Calling the Client Adapter
private void CallBAQUsingAdapter()
{
	try
	{
		// Declare and create an instance of the Adapter.
		DynamicQueryAdapter adapterDynamicQuery = new DynamicQueryAdapter(this.oTrans);
		adapterDynamicQuery.BOConnect();
 
		// Declare and Initialize Variables
		string BAQName = "DIEN-HASO";
		Ice.BO.QueryExecutionDataSet ds = new Ice.BO.QueryExecutionDataSet();
 
		// Add Parameter Rows
		// Definition: AddExecutionParameterRow(string ParameterID, string ParameterValue, string ValueType, bool IsEmpty, Guid SysRowID, string RowMod)
		// Possible ValueTypes: nvarchar, int, decimal, date, datetime, bit, uniqueidentifier, bigint
		// IsEmpty indicates if your passed value Is Empty because if it is, you can define in your params to use a default value if empty.
		// Typically you use string.IsNullOrEmpty(yourValueVariable) but if you are hard coding a value then you can simply set it to false
		ds.ExecutionParameter.AddExecutionParameterRow("QuoteNumber", "10003", "int", false, Guid.Empty, "A");
		ds.ExecutionParameter.AddExecutionParameterRow("FirstName", "Bill", "nvarchar", false, Guid.Empty, "A");
 
		// Call Adapter method
		adapterDynamicQuery.ExecuteByID(BAQName, ds);
 
		// Lets Loop through our results
		if (adapterDynamicQuery.QueryResults.Tables["Results"].Rows.Count > 0)
		{
			foreach (DataRow item in adapterDynamicQuery.QueryResults.Tables["Results"].Rows)
			{
				// In E9 you used TableName.Column in E10 it is TableName_Column
			    string val = item["QuoteHed_QuoteNum"].ToString();
			}
		}
 
		// Cleanup Adapter Reference
		adapterDynamicQuery.Dispose();
 
	} catch (System.Exception ex)
	{
		ExceptionBox.Show(ex);
	}
}