Skip to main content
14-Alexandrite
March 6, 2023
Solved

how to map a database value to the new property created in a thing.

  • March 6, 2023
  • 1 reply
  • 663 views

There is a MSSQL database Thing. I would like to add a new property to this thing as "TempValue" and  then map a sql query to this property. How can this be done ?

 

Best answer by jensc

Hello,

 

The only way I know how to do this is to create your SQL query, then call that query from a javascript service where you then would set your property value using the returned value.

 

Regards,

Jens

1 reply

jensc17-PeridotAnswer
17-Peridot
March 6, 2023

Hello,

 

The only way I know how to do this is to create your SQL query, then call that query from a javascript service where you then would set your property value using the returned value.

 

Regards,

Jens