on 2012 Feb 06 6:23 AM
- <payload operations="">
- <MT_Outlettest_B1 xmlns="http://xxxx.com/CD/B1/MasterData/Outlettest">
<CreateDate />
<DSTRB1 />
<DSTRB2 />
<SCODE />
<STATUS />
<SALESORG />
</MT_Outlettest_B1>
</payload>
<query id="httpheader.???" value="" />
</call>
</Payload>
- <Payload Role="C" id="atom1" system="0010000117" mode="single" method="Automatic detection by key word(Automatic detection by key word)" sql="SELECT CreateDate, T0.[U_DSTRB], T0.[U_DSTRB],T0.[U_SCODE], T0.[U_STATUS], T0.[U_SALESORG] FROM "@CW_PJP" T0 where datename(dw,CreateDate) = 'Monday'" disable-output-escaping="false">
- <ResultSet xmlns="urn:com.sap.b1i.adapter:jdbcadapter" rowCount="1">
- <Row>
<CreateDate>2011-11-07 00:00:00.0</CreateDate>
<U_DSTRB>DMS_TEST</U_DSTRB>
<U_DSTRB>DMS_TEST</U_DSTRB>
<U_SCODE>1</U_SCODE>
<U_STATUS />
<U_SALESORG />
</Row>
</ResultSet>
</Payload>
Here when i am using sql cal the data is taking from table but its not set in paload operation
I have used this function
<CreateDate>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='C' and ./@id='atom1']/jdbc:ResultSet/jdbc:Row/jdbc:createdate"></xsl:value-of>
</CreateDate>
but its not geting the value from result set of sql query.
Can any one help me?
Edited by: Sinha_Sinha on Feb 8, 2012 5:27 AM
Hi Sinha,
XPATH is case sensitive.
a reference to createdate will not find <CreateDate>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi john
thanks for reply
its value coming from result set . when i used payload role "R" then its set the value
but when i set the value in payload role "X" its not seting the value.
can you tell me why its is hapening?
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:b1e="urn:com.sap.b1i.sim:b1event" xmlns:b1ie="urn:com.sap.b1i.sim:b1ievent" xmlns:bfa="urn:com.sap.b1i.bizprocessor:bizatoms" xmlns:jdbc="urn:com.sap.b1i.adapter:jdbcadapter" xmlns:rfc="urn:sap-com:document:sap:rfc:functions" xmlns:sim="urn:com.sap.b1i.sim:entity" xmlns:utils2="com.sap.b1i.bpc_tools.Utilities" xmlns:vpf="urn:com.sap.b1i.vplatform:entity" xmlns:xci="urn:com.sap.b1i.xcellerator:intdoc" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" bfa:force="" vpf:force="" jdbc:force="" rfc:force="" b1ie:force="" b1e:force="" xci:force="" sim:force="" utils2:force="">
<xsl:output method="xml" encoding="UTF-8" indent="yes"></xsl:output>
<xsl:param name="atom"></xsl:param>
<xsl:param name="sessionid"></xsl:param>
<xsl:variable name="msg" select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']"></xsl:variable>
<xsl:variable name="vpSender" select="/vpf:Msg/vpf:Header/vpf:Sender/@Id"></xsl:variable>
<xsl:variable name="vpObject" select="/vpf:Msg/vpf:Header/vpf:Sender/@ObjId"></xsl:variable>
<xsl:variable name="vpReceiver" select="/vpf:Msg/vpf:Header/vpf:ReceiverList/vpf:Receiver[./@handover='P']/@Id"></xsl:variable>
<xsl:variable name="vpvar" select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='C' and ./@id='atom1']/@value"></xsl:variable>
<xsl:template match="/">
<Msg xmlns="urn:com.sap.b1i.vplatform:entity">
<xsl:copy-of select="/vpf:Msg/@*"></xsl:copy-of>
<xsl:copy-of select="/vpf:Msg/vpf:Header"></xsl:copy-of>
<Body>
<xsl:copy-of select="/vpf:Msg/vpf:Body/*"></xsl:copy-of>
<Payload Role="X" id="{$atom}">
<xsl:call-template name="transform">
</xsl:call-template>
</Payload>
</Body>
</Msg>
</xsl:template>
<xsl:template name="transform">
<xsl:call-template name="setCall"></xsl:call-template>
<xsl:copy-of select="$msg/*"></xsl:copy-of>
</xsl:template>
<xsl:template name="setCall">
<call xmlns="">
<out:MT_test_B1 xmlns:out="http://abc.com/CD/B1/MasterData/test">
<!--0 or many of these elements are allowed, order doesn't matter-->
<DSTRB1>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='C' and ./@id='atom1']/jdbc:ResultSet/jdbc:Row/jdbc:U_DSTRB"></xsl:value-of>
</DSTRB1>
</out:MT_test_B1>
<query id="httpheader.???" value=""></query>
</call>
</xsl:template>
</xsl:stylesheet>
User | Count |
---|---|
105 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.