I'm trying to use a string input in my query to return the columns based on the tableName input provided but i'am seeing this error result and here is my script:
When the query service is called with the input the query executed looks like:
and so i think this syntax should be correct. Any advice on this?
Message was edited by: Sushant Pandey branched from https://community.thingworx.com/message/59921#59921 as new question
For String substitution you'd want to use << >> instead of [[ ]]. I believe this is discussed more at length here under the topic JDBC Extensibility (at the end of that documentation)
Hope this'd help.