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

Use Input parameter to generate sql queries

  • March 31, 2025
  • 2 replies
  • 511 views

Hello

 

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

 

Any help will be appreciated

 

Thanks

Best answer by bchaudhary_448008

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

2 replies

S
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

    B
    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

      Terms & ConditionsCookie settingsAccessibility statement