Skip to Content
Jul 24, 2019 at 03:19 PM

Issue with executing a basic query in Hana 2.0 SPS 03 through xsjs

175 Views Last edit Jul 24, 2019 at 03:24 PM 2 rev

I am trying to execute the below code in the Hana 2.0 SPS 03 environment.

TEMP_DATA is the context name and Entity is the entity name. I don't have namespace in my project.

Straight forward but when I run this, I get an error "500 invalid column name: ID" but when I change the query to add a double quotes to the id column(as shown below) my query executes.

var query = 'select "id" as "Identifier" FROM TEMP_DATA.Entity';

But this would be a problem to me since I have made my context and entity names to match my 1.0 names, so the code in 1.0 works in 2.0. If I have to add quotes for the columns in the select clause, I have to manually do it for all the queries in all the files which would time consuming. So is there a way to make all the queries in 1.0 artifacts to work in 2.0 with just the table name change?

P.S. I found the same issue in procedures and functions too


unnamed-1.png (8.8 kB)