cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Wildcard in SQL query with input param

Highlighted
Regular Member

Wildcard in SQL query with input param

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.....

 

Solutions anyone?

12 REPLIES 12

Re: Wildcard in SQL query with input param

This could have been changed due to the changed security policies. I will verify and get back to you/this thread with an update.

Re: Wildcard in SQL query with input param

This was part of security updates, works to spec.

Re: Wildcard in SQL query with input param

So, when you say, 'works to spec', are you saying that this SQL query should in fact work? 

Re: Wildcard in SQL query with input param

Wildcard should not work, sql queries should work.

Re: Wildcard in SQL query with input param

So, how can I execute a SQL query that needs to take in a variable? What's the work-around for this?

Re: Wildcard in SQL query with input param

Re: Wildcard in SQL query with input param

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.

Re: Wildcard in SQL query with input param

I don't think we support wildcard without a variable/security patches.

Re: Wildcard in SQL query with input param

Please elaborate on what 'variable patches' are.