Difference between revisions of "Codeunit/Integration/IntegrationFieldLookupKey"
Jump to navigation
Jump to search
old>Admin (Created page with '== What it does == Looks up another value based on the string provided, for use in a scheduled integration. Example: SELECT Name FROM user WHERE Email = '@VALUE@'; == How to…') |
old>Admin |
||
| Line 1: | Line 1: | ||
== What it does == | == What it does == | ||
Looks up another value based on the string provided, for use in a scheduled integration. | Looks up another value based on the string provided, for use in a scheduled integration. | ||
A lookup will be executed sustituting the @VALUE@ in the SQL expression passed to the codeunit. | |||
Example: | Example: | ||
SELECT Name FROM user WHERE Email = '@VALUE@'; | SELECT Name FROM user WHERE Email = '@VALUE@'; | ||
== How to invoke == | == How to invoke == | ||
Revision as of 10:29, 18 March 2013
What it does
Looks up another value based on the string provided, for use in a scheduled integration.
A lookup will be executed sustituting the @VALUE@ in the SQL expression passed to the codeunit.
Example:
SELECT Name FROM user WHERE Email = '@VALUE@';
How to invoke
Insert value in field mapping Designer > Integration > Import sources > [intergration] > [fieldmapping] > Codeunit handler
dk.p2e.blanket.codeunit.common.IntegrationFieldLookupKey
Configuration
Insert an SQL expression in:
[fieldmapping] > Configuration values
The expression must contain the parameter: @VALUE@
Developer info
- Type: CodeunitTranslator
- Security: None