I have a table with 4 columns: student_name,maths_marks,physics_marks,chemistry_marks
I am using the adapter select service to get the records from the table.
The result of all the marks column are objects (not strings).
Now the output which is expected is
student_name : total_marks(sum of marks columns).
Can someone help me how this can be done.(I want only flowservice without javaservice).This should be done through best practices.
Hi Gyanesh,
What Type of Database are using ORALCE/SQL Server can you be specific and
If it is ORACLE i assume under teh select adapter service under the ‘select’ tab u are mentioning the equation student_name : total_marks(sum of marks columns)., check that data type it is mentioned. This issue requires attention at the adapter service. if you are not using the equation in select tab, then u must add up the marks in the flow service
using transforms addInts. Check what is the datatype of the output and also check under the properties of the output whether u have mentioned it to be an object value
Hi Gyanesh,
Here is the thing. Just create an document which is to exactly in form of the XML you wanted.
Results → document name & document
Total Marks (This is documentlist with following fields. Same as the Result Document List in the Adapter service )
Name Maths Chemistry Physics → are the String values.
Next you need to do is to map the db out put to this document. After this use
the DocumenttoXMLString Service and you will have the xml string. There is no need you to go to Loop
When you use the document to XML string service following will be the o/p