Codeunit/Integration/IntegrationFieldLookupKey - Revision history

Tvi: 5 revisions imported

2021-12-10T10:51:16Z

5 revisions imported

← Older revision

Revision as of 12:51, 10 December 2021

old>Admin: /* Configuration */

2013-03-18T09:32:30Z

Configuration

← Older revision		Revision as of 11:32, 18 March 2013
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

old>Admin: /* What it does */

2013-03-18T09:32:20Z

What it does

← Older revision		Revision as of 11:32, 18 March 2013
Line 3:		Line 3:

	A lookup will be executed sustituting the @VALUE@ in the SQL expression passed to the codeunit.		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.		Note that the @VALUE@ is SQL escaped for security reasons.


	== How to invoke ==		== How to invoke ==

old>Admin at 09:31, 18 March 2013

2013-03-18T09:31:44Z

← Older revision		Revision as of 11:31, 18 March 2013
Line 6:		Line 6:
	Example:		Example:
	SELECT Name FROM user WHERE Email = '@VALUE@';		SELECT Name FROM user WHERE Email = '@VALUE@';

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


	== How to invoke ==		== How to invoke ==

old>Admin: /* What it does */

2013-03-18T09:29:39Z

What it does

← Older revision		Revision as of 11:29, 18 March 2013
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 ==

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…'

2013-03-18T09:28:46Z

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…'

New page

== 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 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