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

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

SOLVED
Highlighted

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

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

Hi @svisveswaraiya- 

 

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 4

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

Hi @svisveswaraiya-

 

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

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

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?

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

Hi @svisveswaraiya- 

 

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

 

Regards.

 

--Sharon

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

Hi @svisveswaraiya- 

 

If the previous response answered your questions, please mark it as the Accepted Solution for the benefit of others with the same questions.

 

Regards.

 

--Sharon