Ask a Question

PostgreSQL not able to remove tableName appended to columnName in ReadyAPI2.2

RachelJones
New Contributor

PostgreSQL not able to remove tableName appended to columnName in ReadyAPI2.2

If my query "Select Tablename.ID AS VALUE, 'ID' AS key From Schema.TableName Where Schema.Tablename.location = '${#TestCase#Doc}'

runs in Oracle it gives me resultset as 

<Results>
<ResultSet fetchSize="0">
<Row rowNumber="1">
<.VALUE>5955</.VALUE>
<KEY>ID</KEY>
</Row>
</ResultSet>
</Results>

 

 

but when it runs on PostgreSql it gives me 

<Results>
<ResultSet fetchSize="0">
<Row rowNumber="1">
<Tablename.VALUE>5955</Tablename.VALUE>
<KEY>ImageID</KEY>
</Row>
</ResultSet>
</Results>.

 

Can anyone comment on this or the possible solution

1 REPLY 1
NBorovykh
Moderator

Hi @RachelJones,

 

If you replace Tablename.ID in your query with ID, does it work better for you?

 

Natalie
Customer Care Team

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓
cancel
Showing results for 
Search instead for 
Did you mean: