I need to make a SQL query in Thingworx. The query should read (if I were creating it directly):
SELECT * FROM MyDB.MyTable where Name like '%Name_Input%'
Another PTC forum post had recommended this as a possible solution:
SELECT * FROM MyDB.MyTable where Name like '%' || [[Name_Input]] || '%'
But this query (above) does not work. The post was from the year 2014 and I'm currently using 8.4.1, so I'm guessing that's the issue.....
This could have been changed due to the changed security policies. I will verify and get back to you/this thread with an update.
It tells me how to use a variable from a user (fine, I know how to do that), but it doesn't mention being able to user wildcards WITH the variable.
I know I can use wildcards WITHOUT a variable.