Question

How to get the first data set record with the script rule?

Answer

The attached sample project has 3 data set records and will return data of the first matched record if the Vendor field is not empty and the value exists in the data set. The script rule is created under the Vendor field with comments describing steps in more detail:

Here are some test results in the document definition with the following data set:

• The Vendor value returns nothing as it is not matched with any record:

• The Vendor2 value returns the ID and Data from the data set:

Additional information

IRuleContext
IDataSet
IDataSetQuery
IRecordset
IDataSetRecord