Devart Cin7 Core Lookup component joins the input data with the data from Cin7 Core objects. It has the following custom properties:
Property |
Description |
|---|---|
BatchSize |
Not supported for Cin7 Core. |
CacheSize |
The number of the queried rows from the lookup object to cache. Default value is 2000. |
CaseInsensitiveLookup |
Determines whether matching is case insensitive. Default value is False. |
LocalSQLEngine |
Determines the Devart Cin7 Core Lookup behavior when the lookup condition cannot be converted to Cin7 Core API calls. If this property is set to True, Devart Cin7 Core Lookup selects all the data from the Lookup Object and performs the lookup locally over the cached data. If this property is set to False, Devart Cin7 Core Lookup throws the corresponding error. Default value is True. |
Lookup Object |
The name of an Cin7 Core object to find matching rows from. |
NoMatchAsError |
Determines whether to redirect the input rows that do not match at least one row in the lookup object to the Error output. Default value is False. |
UseFirstMatchInMultipleResults |
Determines whether to pick the first row from the lookup object if more than one matching row is found. Default value is True. If set to false, the input rows, for which multiple matches are found, are redirected to the Error Output with the corresponding error message. |
UseNullsIfNoMatchFound |
Determines whether to redirect rows with matches not found to the match output and fill the corresponding lookup columns with NULLs for such rows. Default value is False. |