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

Use table name as parameter for SQL command and SQL query

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

nmillesonAnswer
17-Peridot
July 21, 2020

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

View in thread

3 replies

nmilleson17-PeridotAnswer
17-Peridot
July 21, 2020

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

Translate
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

Translate
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

Translate
Terms & ConditionsAccessibility statement