Skip to main content
SS_131753593-Newcomer
3-Newcomer
March 31, 2025
Solved

Use Input parameter to generate sql queries

Hello

 

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

 

Any help will be appreciated

 

Thanks

bchaudhary_448008Answer
5-Regular Member
April 1, 2025

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

View in thread

2 replies

Surya_Tiwari16-Pearl
16-Pearl
April 1, 2025

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

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

Translate
    bchaudhary_4480085-Regular MemberAnswer
    5-Regular Member
    April 1, 2025

    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

    Translate
      Terms & ConditionsAccessibility statement