Topic
1 reply Latest Post - ‏2012-05-01T10:13:14Z by IdanAdar
SystemAdmin
SystemAdmin
570 Posts
ACCEPTED ANSWER

Pinned topic Not able to use transformation in SQL Adapter

‏2012-04-30T19:39:10Z |
Hi,
When I try to use the *transformation *parameter in my SQL Procedures' input, I see the following warning in the console


15:36:46,618 WARN  [SQLQuery] The parameter transformation is not known and will be ignored.


But in the documentation, this information is mentioned.Below is the procedure that I'm using.


var userListListQuery = WL.Server .createSQLStatement(
"Select * from User_Table"); function getUserList() 
{ var input=
{ preparedStatement : userListListQuery , parameters : [], transformation : 
{ type : 
'xslFile', xslFile : 
'UserListFilter.xsl' 
} 
}; 

return WL.Server.invokeSQLStatement(input); 
}


Am I doing this in the correct way? Can you please let me know?
  • IdanAdar
    IdanAdar
    288 Posts
    ACCEPTED ANSWER

    Re: Not able to use transformation in SQL Adapter

    ‏2012-05-01T10:13:14Z  in response to SystemAdmin
    This is because in SQL the result you get is not in XML, thus you cannot transform it.