Hi folks,
I have the following data-config.xml. Is there a way to
let transformation take place after executing SQL "select comment from
Rating where Rating.CourseId = ${Course.CourseId}"? In MySQL database,
column CourseId in table Course is integer 1, 2, etc;
template transformation will make them like Course:1, Course:2; column
CourseId in table Rating is also integer 1, 2, etc.
If transformation happens before executing "select comment from Rating
where Rating.CourseId = ${Course.CourseId}", then there will no match for
the SQL statement execution.
<document>
<entity name="Course" transformer="TemplateTransformer" query="select *
from Course">
<field
column="CourseId" template="Course:${Course.CourseId}" name="id"/>
<entity name="Rating" query="select comment from Rating where
Rating.CourseId = ${Course.CourseId}">
<field column="comment" name="review"/>
</entity>
</entity>
</document>
