====== Where-used list for mapping functions ======

If you want to obtain certainty about the use of a mapping function, you can proceed in the same way as described under [[en:transformation:mappings:verwendungsnachweis]].

{{:images:sign_warning.png?nolink|}}**Note:** Mapping functions can be used in mappings as well as in job definitions ((Especially with [[en:prozessdefinition:jobs:jobsteps:allgemein:entityifcase]] but also with other job steps (where expressions can be specified.)). For the search for complex expressions, special characters ((such as quotation marks, backslashes, percentage signs, square brackets on etc.)) must be correctly **escaped**.

**As an alternative to the content search in eBiss Dump files, you can also search directly in the database.**


===== Example SQL query for searching in mappings =====

<code sql>
DECLARE @find varchar(70)   
--SET @find =  '$SerialShippingContainerCode';
SET @find =  'SG_16/RFF/DG_C506[[]@DE_1153=''VN'']/@DE_1154';

SET @find = CONCAT('%',@find,'%');

with Mappings as (
    select (select Name from  [Node] where Oid = Node_oid) as Node, Name, CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), [MapBytes])) as MapDefinition
    from [MapDef]
)
select Node,Name from Mappings where MapDefinition like @find;
</code>

===== Example SQL Query for Searching in Jobs =====

<code sql>
DECLARE @find varchar(70);

SELECT @find = 'Order Outbound';

SET @find = CONCAT('%',@find,'%');

with Jobs as (
    select (select Name from  [Node] where Oid = Node_oid) as Node, Name, CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), [JobBytes])) as JobDefinition
    from [JobDef]
)
select Node,Name from Jobs where JobDefinition like @find;
</code>

{{:images:sign_warning.png?nolink|}}**Note: ** Mapping functions also apply to job steps that support the specification of **Expressions**((I.e. [[en:prozessdefinition:jobs:jobsteps:allgemein:entityifcase]] or [[prozessdefinition:jobs:beispiele:messageselector]])).