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

The expression must contain the parameter: @VALUE@

@@ Line 3: / Line 3: @@
 A lookup will be executed sustituting the @VALUE@ in the SQL expression passed to the codeunit.
-Example:
-  SELECT Name FROM user WHERE Email = '@VALUE@';
 Note that the @VALUE@ is SQL escaped for security reasons.
 == How to invoke ==