Add two search filters on Material Queue Manager with Customer ID and Order ID

Epicor ERP 10
,
6

Thank you for the feedback.

you could use post-processing and remove all orders except the one your looking for
I tried this(1st) method but it doesn’t resolve our performance issue so it will not help us

AND 2nd suggestion seems good, can you please share the logic/code? how do you call the material queue.getrows method? and how do you bind data to MQManager?

I have tried below code but showing column mismatch (Columns order mismatch) (Does Not work)

private void CallMaterialQueueAdapterGetRowsMethod()
{
try
{
string whereClause = string.Empty;
Ice.Core.Session userSess = (Ice.Core.Session)MaterialQueueMgrEntryForm.Session;

		MaterialQueueAdapter adapterMaterialQueue = new MaterialQueueAdapter(this.oTrans);
		adapterMaterialQueue.BOConnect();
		
		Ice.Lib.Searches.SearchOptions opts = new SearchOptions(SearchMode.AutoSearch); 
		opts.DataSetMode = DataSetMode.RowsDataSet; 
		
		whereClause = string.Format("Company = '{0}' AND OrderNum = {1}", Convert.ToString(userSess.CompanyID), txtOrderNo.Text.Trim());
				
		opts.NamedSearch.WhereClauses.Add("MtlQueue",whereClause);
		bool morePages = false;
		System.Data.DataSet dsMaterialQueue = adapterMaterialQueue.GetRows(opts, out morePages);
	Gridmtl.DataSource = dsMaterialQueue;

		adapterMaterialQueue.Dispose();

	} catch (System.Exception ex)
	{
		ExceptionBox.Show(ex);
	}
}