Skip to main content
P
PabloCastilla12-Amethyst
12-Amethyst
November 3, 2022
Solved

Calling Thing properties in a SQL command in Twx

  • November 3, 2022
  • 1 reply
  • 1069 views

Greetings,

 

To provide a context:

I'm building an app to store data from an experience. The process is simple, the app gets data from users and share it to Twx, Twx sends the data to pSQL and gets all data stored in the db to show it in a mashup.

 

Now, I'm triying to send the data to postgresql. 

I created a js service to get the data from vuforia. I just read that I can't use "me.property" in SQL commands, that I should create variables in the js service and invoke those variables into the SQL command. But I'm not sure how.

A different way I thought I could use was to call the Thing property into the SQL. But It didn't work, I think is because I didn't use the right command.

Another way was to input the data directly into the SQL but I will have the same problems later in the process because I will need the data to use it in different services.

 

Do you have any advise? Is there any guide about programming SQL in Twx? 

 

Thank you a lot for all your advises. 

Best answer by PabloCastilla

Hello @bchaudhary_448008 ,

 

Thanks for your answer. I'll check those articles, I've just solved the issue by inputting the data twice, first for the js service and the second for the SQL service. I'm not sure if it's efficient, but it works. 

 

May I ask if there's a way to use the Thing properties in the SQL scripts? How can I call/invoke them in the SQL scripts?

1 reply

B
bchaudhary_4480085-Regular Member
5-Regular Member
November 4, 2022

Hello @PabloCastilla ,

 

We do not have a specific guide that contains the sql commands/ queries on TWX. However, Pls check the given article and the result will always be in the form of infotable which you can use later in other services very swiftly.

https://www.ptc.com/en/support/article/cs366970

Also pls chcek a very basic article explaining the use of sql command and query in TWX.

https://www.ptc.com/en/support/article/cs209612

 

also, you can share the errors that you are facing while trying the SQL with TwX.

 

Regards

Bhawna

 

    P
    PabloCastilla12-AmethystAuthorAnswer
    12-Amethyst
    November 4, 2022

    Hello @bchaudhary_448008 ,

     

    Thanks for your answer. I'll check those articles, I've just solved the issue by inputting the data twice, first for the js service and the second for the SQL service. I'm not sure if it's efficient, but it works. 

     

    May I ask if there's a way to use the Thing properties in the SQL scripts? How can I call/invoke them in the SQL scripts?

    Terms & ConditionsAccessibility statement