We would like to access to DataSets from IRuleContext.
Does anybody have simple and working example of CreateQuery method - IDataSet object
Does anybody have simple and working example of CreateQuery method - IDataSet object
0 out of 0 found this helpful
Comments
4 comments
You can find some sample scripts in invoice projects.
Sample script should look something like this:
// Data set
IDataSet dataSet = Context.DataSet("PurchaseOrdersItems"); //your dataset
IDataSetQuery query = dataSet.CreateQuery(); //select query
query.AddValue("PONumber", orderNumber); //select parameters
query.AddValue("BUId", buId); //
int recordsCountInDataset = dataSet.GetRecordsCount( query ); //you can also get records bt calling GetRecords (IDataSetQuery : query) : IRecordset
Refer to IDataSet object in help file for more information on availabla methods.
Regards
Tim
thank you on your swift response!
Hello,
how to search with like operator?
Hello,
There is no standard way to do this, please contact your regional support to find workaround.
Please sign in to leave a comment.