Erp-baq send list parameter to a baq

[Chan213419 (Jeremy Chance)]

I can’t share it directly, though I’d love to, but here’s all the info you’d need to build it:

Assembly:

Service:

Params:

Function Code:

CallService<DynamicQuerySvcContract>(dqSvc =>
{     
  Ice.Tablesets.QueryExecutionTableset QEts = dqSvc.GetQueryExecutionParametersByID("JobGrid");
  QEts.ExecutionParameter.Clear();
  
  var payload = new {
      JobsList = this.pJobsList
  };

  var JobsList = payload.JobsList.Split(',');
  foreach (var job in JobsList)
  {
      QEts.ExecutionParameter.Add(new ExecutionParameterRow 
      {
        ParameterID = "JobNum",
        ParameterValue = job.Trim().ToString()
      });
  }
      
  DataSet qeDS = dqSvc.ExecuteByID("JobGrid", QEts);
      
  if (qeDS.Tables[0].Rows.Count>0)
  {
    this.oDs = qeDS; 
  }        
});

I hope this helps.

[Chan213419 (Jeremy Chance)]

@jbooker

Okay then I was wrong. I’m pretty sure the IN operator can take a single-quoted, comma delimited list via one of the option outlined above.

Maybe if you choose ‘specified constant list’ and just left it empty? Too late for me to try, but worth a shot.

[jbooker (Josh Booker)]

Yeah either that or I’m thinking of passing pure client-side Where clauses which I know for sure does indeed work (aside from a couple caveats already mensioned). Distinction being the IN() criteria is not modeled in the BAQ designer.

like:

@jbooker

{
	"ExecutionSetting": [
		{
			"Name": "PageSize",
			"Value": 100
		},
		{
			"Name": "PageNum",
			"Value": 1
		},
		{
			"Name": "NeedTotal",
			"Value": false
		},
		{
			"Name": "Select",
			"Value": "[JobHead_JobNum]"
		},
        {
            "Name": "Where",
            "Value": "JobNum IN(?{TransView.Jobs})"
        }
	],
	"ExecutionParameter": [
		{
			"IsEmpty": true,
			"ParameterID": "JobNum",
			"ParameterValue": "",
			"ValueType": "nvarchar"
		}
	]
}

[Chan213419 (Jeremy Chance)]

Oh, I see what you’re saying now! Next time I come across this challenge, I’ll be sure to come back here. That’s way easier!

[utaylor (Utah Taylor)]

Thanks!

[jbooker (Josh Booker)]

FWIW, the BAQ Options > Where: IN() method does seems to work well.
using this syntax:

Job_JobNum IN (?{TransView.JobsSQL})

see:

Custom Part Context Menu Open With

PSS- I got the grid.ViewOptions > BAQ Options > WHERE expression to work for IN() clause using this technique with this syntax Part_PartNum IN (?{TransView.PartsSQL}) So now it works for a Context Menu ValueIn and a multi-select searchResult with mutli-paste using SearchChipSelector component: [ContextMenu-SearchChip]