Hi experts,
We have been able to establish connectivity to a HANA database successfully.
The HANA stored procedure is expecting the values to be passed, enclosed in single quotes - 'Value1, Value2'.
A query like below works perfectly fine.
SELECT * from DB_SCHEMA.VIEW_NAME('placeholder' = ('$$list_name$$','Value1,Value2'))
However when I try to pass this list as a parameter, I am getting an error.
SELECT * from DB_SCHEMA.VIEW_NAME('placeholder' = ('$$list_name$$',{parameter}))
Has anybody integrated with HANA DB before and has a reference to how we can achieve this by passing dynamic values via parameter with the main criteria being include parameter values in single quotes?
Discussion posts and replies are publicly visible
Concatenate parameter with single quotesSELECT * from DB_SCHEMA.VIEW_NAME('placeholder' = ('$$list_name$$', ' ' parameter ' '))
Thanks for your response. Shubham.
Unfortunately, it doesn't work. For Appian to detect something as a parameterName it is necessary to enclose it in curly braces without anything before or after. We can only play with what values go into the parameter and not the syntax you have suggested above.