Skip to main content
Sarma1-Visitor
1-Visitor
May 17, 2019 10:07 AM UTC
Question

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

3 replies

PaiChung22-Sapphire I
22-Sapphire I
May 17, 2019 12:16 PM UTC

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

Translate
Sarma1-VisitorAuthor
1-Visitor
May 21, 2019 7:59 AM UTC

Thanks for the reply.

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

Translate
PaiChung22-Sapphire I
22-Sapphire I
May 23, 2019 11:46 AM UTC

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

Try aliasing the column to a different name?

Translate
Terms & ConditionsAccessibility statement