Hi All,
I have data-config.xml as below:Script Transformer is omitted.
<dataConfig>
<dataSource driver="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:/temp/example/ex" user="sa" />
<script><![CDATA[ function f1(row) {
row.put('message', 'Hello World!'); return
row; } ]]></script>
<document name="products">
<entity name="item" query="select NAME,BSIN from items"
transformer="script:f1">
<field column="NAME" name="id" />
<field column="BSIN" name="bsin" />
<entity name="brands" query="select brandname from brand where
bsin='${item.BSIN}'" >
<field name="brand" column="BRAND" />
<field name="cname" column="namedesc" />
</entity>
</entity>
</document>
</dataConfig>
I am able to access NAME and BSIN in the function f1. I am not able to
access the brand and cname. Is there any way i can access brand and cname
from child entity in script transformer ?
Thanks in advance.
Regards,
Pavan .P.Patharde