[ https://issues.jboss.org/browse/TEIIDDES-2040?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2040: ---------------------------------------- I captured the BEFORE and AFTER transformation info for one operation below. Note the "nested" mapping with referenced input. We'll need to track down what logic is resolving/reconciling/setting these values by opening the t-editor. SQL after Create Web Service: {code:xml} <transformationMappings xsi:type="transformation:SqlTransformationMappingRoot" xmi:uuid="mmuuid:bcb7929b-7d70-4567-94a6-379bb9fff442" outputs="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38" target="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38"> <helper xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:f9a235d7-f072-4078-b01c-98bb2b5a39ac"> <nested xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:e5c11537-55e8-4889-8771-a2986b57d58a" selectSql="CREATE VIRTUAL PROCEDURE BEGIN DECLARE string VARIABLES.IN_exampleVar ;VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()=&quot;exampleName&quot;]');SELECT * FROM AAA_View.SHIP_VIA_OutputView; END"/> </helper> {code} SQL After d-clicking, opening t-editor and validation fixed {code:xml} <transformationMappings xsi:type="transformation:SqlTransformationMappingRoot" xmi:uuid="mmuuid:bcb7929b-7d70-4567-94a6-379bb9fff442" outputs="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38" target="mmuuid/7d7f17bd-a415-4023-882b-fd0c54464a38"> <helper xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:f9a235d7-f072-4078-b01c-98bb2b5a39ac"> <nested xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:e5c11537-55e8-4889-8771-a2986b57d58a" selectSql="CREATE VIRTUAL PROCEDURE BEGIN DECLARE string VARIABLES.IN_exampleVar ;VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()=&quot;exampleName&quot;]');SELECT * FROM AAA_View.SHIP_VIA_OutputView; END"/> <aliases xmi:uuid="mmuuid:a8fa3afb-1d55-4a4f-98f5-e5ab987f2ad4" alias="SHIP_VIA_OutputView"> <aliasedObject href="AAA_View.xmi#mmuuid/a46365c7-621b-4905-bc5f-fe40e3b42026"/> </aliases> </helper> <nested xsi:type="transformation:TransformationMapping" xmi:uuid="mmuuid:1ceedbca-a363-491b-9a48-0eff07d78a04" outputs="mmuuid/a8c4a2a8-fe48-4754-b155-8ba049114ce5"/> <inputs href="AAA_View.xmi#mmuuid/a46365c7-621b-4905-bc5f-fe40e3b42026"/> </transformationMappings> {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira