cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

Thingworx SQL Query output different.

Sarma
6-Contributor
6-Contributor
‎May 17, 2019 06:07 AM
‎May 17, 2019 06:07 AM

Thingworx SQL Query output different.

Hi,
I am facing same problem.
Data from TWX SQL SERVICE & SQL retrieved values are not matching for one column data. Number of rows returned are same in both cases.
Please share if you have any resolution... This is very critical for me.
Thanks in advance
Sarma

Labels:
0 Kudos
Notify Moderator
3 REPLIES 3
PaiChung
22-Sapphire I
22-Sapphire I
(To:Sarma)
‎May 17, 2019 08:16 AM
‎May 17, 2019 08:16 AM

Are your datashapes mismatched? even upper lower case can make a difference

0 Kudos
Notify Moderator
Sarma
6-Contributor
6-Contributor
(To:PaiChung)
‎May 21, 2019 03:59 AM
‎May 21, 2019 03:59 AM

Thanks for the reply.

I have ensured that the Datashape is correct along with letter case properly. Still I see the issue

0 Kudos
Notify Moderator
PaiChung
22-Sapphire I
22-Sapphire I
(To:Sarma)
‎May 23, 2019 07:46 AM
‎May 23, 2019 07:46 AM

Are you missing a column? Is it at all a 'reserved' word perhaps?

Try aliasing the column to a different name?

0 Kudos
Notify Moderator
Top Tags