How can I use the GetResultSets method in BOI to return a data set that does not match a certain criteria. Below is my sample code that is trying to find all Sales Orders where the CurrentInvoiceNo is not empty. However, this does not return any results. Any help here is appreciated.
string filter = "CurrentInvoiceNo$!=\"\"";
string[] orderNumbers = null;
using (DispatchObject so_order_bus = new DispatchObject(pvx.InvokeMethod("NewObject", "SO_SalesOrder_bus", oSS.GetObject())))
{
string strResults = "";
string junk = "";
object[] getResultSetParams = new object[] { "SalesOrderNo$", "CustomerNo$", strResults, junk, filter, "", "" };
so_order_bus.InvokeMethodByRef("nGetResultSets", getResultSetParams);
orderNumbers = getResultSetParams[2].ToString().Split(SEP);
}
