cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

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

AP_10483126
11-Garnet

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

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 ?

 

ACCEPTED SOLUTION

Accepted Solutions
jensc
17-Peridot
(To:AP_10483126)

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

View solution in original post

1 REPLY 1
jensc
17-Peridot
(To:AP_10483126)

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

Announcements


Top Tags