Thingworx SQL Query output different.

[Sarma]

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

[PaiChung]

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

[Sarma]

Thanks for the reply.

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

[PaiChung]

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

Try aliasing the column to a different name?