PostgreSQL not able to remove tableName appended to columnName in ReadyAPI2.2
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2018
12:53 AM
09-05-2018
12:53 AM
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
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2018
04:07 AM
09-10-2018
04:07 AM
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.↓↓↓↓↓
Customer Care Team
Did my reply answer your question? Give Kudos or Accept it as a Solution to help others.↓↓↓↓↓
