Skip to main content
S
svisveswaraiya_2859881-Visitor
1-Visitor
January 8, 2019
Solved

I am trying to combine two queries in postgres to use it in thingworx but it shows error.

  • January 8, 2019
  • 4 replies
  • 2008 views

Hi,

I have an staging table "test1" created in Postgresql v9.6 which has all the other tables under a column <tablename>. I wanted to select all data from another table through the staging table "test1".

I used a query SELECT * FROM (SELECT tableName FROM public."Test1" where id='1')  

 

 

How can I solve this? Please provide some help.

Thanks,

Shalini V.

 

Best answer by slangley

Hi @svisveswaraiya_285988 

 

I think this reference doc may answer your questions.  Please let us know if you have further questions after reading this.

 

Regards.

 

--Sharon

4 replies

S
slangleyCommunity Manager
Support
January 11, 2019

Hi @svisveswaraiya_285988

 

You indicated you were trying to query PostgreSQL 9.6.  Is this your model provider or are you using it as a data provider?  This version is not supported if using as the model provider for ThingWorx.

 

Could you provide the error message you are getting?  Have you checked the logs for more information regarding the failure?  Is your query being executed in ThingWorx or are you running this in PostgreSQL?

 

Regards.

 

--Sharon

S
svisveswaraiya_2859881-VisitorAuthor
1-Visitor
January 23, 2019

Hi slangley ,

Thanks for your response.

I am trying to execute this in Postgres and now I have upgraded to 8.2 version of ThingWorx and so using Postgres 9.4. And what is the model provider and data provider? are you reffering to external plug in or the persistence provider?

S
slangleyCommunity ManagerAnswer
Support
January 25, 2019

Hi @svisveswaraiya_285988 

 

I think this reference doc may answer your questions.  Please let us know if you have further questions after reading this.

 

Regards.

 

--Sharon

Terms & ConditionsAccessibility statement