Hi all,
RachelJones, please try adding an event handler TestRunListener.afterStep,
import com.eviware.soapui.impl.wsdl.teststeps.JdbcTestStepResult
if (testStepResult instanceof com.eviware.soapui.impl.wsdl.teststeps.JdbcTestStepResult){
def response = testStepResult.getResponse()
def content = response.getContentAsString()
log.info content
content = content.replaceAll("<TABLENAME.", "<")
content = content.replaceAll("</TABLENAME.", "</")
log.info content
response.setContentAsString(content)
testStepResult.setResponse(response, false)
log.info testStepResult.getResponseContentAsXml()
}
Does this work for you?
Hi ,
I was just curious to know that this is happening only in PostgreSql .
For oracle and SQL it is giving only the alias name. Is this issue related with the ReadyAPI version since i am using 2.2. I will definitely give a try to the proposed solution.
Hi ,
I tried the proposed solution but it does not work.First part is event listener is not invoked.
Second this is a common jdbc step which is working for Oracle .And we are adding the same compatibility in PostgreSql and SQLserver. The assertion is checking for the <value> node from the resultset which is an Alias name in the query.The assertion is getting passed for Oracle and sqlserver but failing for PostgreSql since the value node is appended with tablename <tableName.Value>.
If you can throw some light on this.
Hi RachelJones,
It looks like the issue requires additional investigation. So, in this case, I recommend that you create a new support ticket so that our engineers could look deeper into it.
