Difference between revisions of "Codeunit/Integration/IntegrationFieldLookupKey"

From TempusServa wiki
Jump to navigation Jump to search
old>Admin
old>Admin
Line 17: Line 17:


[fieldmapping] > Configuration values
[fieldmapping] > Configuration values
Example:
  SELECT Name FROM user WHERE Email = '@VALUE@';


The expression must contain the parameter: '''@VALUE@'''
The expression must contain the parameter: '''@VALUE@'''


== Developer info ==
== Developer info ==
* Type: CodeunitTranslator
* Type: CodeunitTranslator
* Security: None
* Security: None

Revision as of 10:32, 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.

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

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

Example:

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

The expression must contain the parameter: @VALUE@

Developer info

  • Type: CodeunitTranslator
  • Security: None