Difference between revisions of "Codeunit/Integration/IntegrationFieldLookupKey"

Revision as of 10:32, 18 March 2013

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.

Note that the @VALUE@ is SQL escaped for security reasons.

Insert value in field mapping Designer > Integration > Import sources > [intergration] > [fieldmapping] > Codeunit handler

  dk.p2e.blanket.codeunit.common.IntegrationFieldLookupKey

Insert an SQL expression in:

[fieldmapping] > Configuration values

Example:

 SELECT Name FROM user WHERE Email = '@VALUE@';

The expression must contain the parameter: @VALUE@

@@ Line 17: / Line 17: @@
 [fieldmapping] > Configuration values
+Example:
+  SELECT Name FROM user WHERE Email = '@VALUE@';
 The expression must contain the parameter: '''@VALUE@'''
 == Developer info ==
 * Type: CodeunitTranslator
 * Security: None