Use Input parameter to generate sql queries

[SS_13175359]

Hello

I am trying to figure out How to use input parameters for SQL in ThingWorx

Any help will be appreciated

Thanks

[Surya_Tiwari]

Hi @SS_13175359. Look at the article below for your reference.

https://www.ptc.com/en/support/article/CS413368

[bchaudhary · Accepted solution]

Hello @SS_13175359 

You can try and Use service input parameters to specify column value into WHERE clause of SQL Query or SQL Command by wrapping parameter name with double square brackets like [[xxx]]

for eg : SELECT * FROM user_data WHERE username = [[xxx]];

Let me know if it still doesn't work

Thanks