Community

Using DataSets in Field Rules scripts - ABBYY FlexiCapture for Invoices

We would like to access to DataSets from IRuleContext.
​Does anybody have simple and working example of CreateQuery method - IDataSet object

Was this article helpful?

0 out of 0 found this helpful

Comments

4 comments

  • Avatar
    Permanently deleted user
    Hello,

    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

    0
  • Avatar
    Dusan Spajzar
    Dear Timur
    ​thank you on your swift response!
    0
  • Avatar
    Permanently deleted user

    Hello,

     how to search with like operator?

    0
  • Avatar
    Permanently deleted user

    Hello,

    There is no standard way to do this, please contact your regional support to find workaround. 

    0

Please sign in to leave a comment.