Skip to main content
S
seanccc17-Peridot
17-Peridot
July 21, 2020
Solved

Use table name as parameter for SQL command and SQL query

  • July 21, 2020
  • 3 replies
  • 1379 views

Hi, 

 

How to use table name as parameter in Database thing for SQL command and query ?   

I tried something like : select * from [[tableName]],  but it doesn't work. 

 

Regards,

Sean

Best answer by nmilleson

Try this instead:  select * from <<tableName>>

3 replies

N
nmilleson17-PeridotAnswer
17-Peridot
July 21, 2020

Try this instead:  select * from <<tableName>>

S
seanccc17-PeridotAuthor
17-Peridot
July 21, 2020

@nmilleson ,

 

Thank you for your quick reply.  I just found it as well and posted it before refreshing the page :  ) 

 

Regards,

Sean

S
seanccc17-PeridotAuthor
17-Peridot
July 21, 2020

I found the answer in https://developer.thingworx.com/en/resources/guides/external-databases . 

 

Just use <<tableName>> in SQL  

 

Regards,

Sean

Terms & ConditionsAccessibility statement